Re: [mssms] Query help

2016-07-21 Thread Andrew Sanders
You could always write a Configuration Item / Baseline to report on a missing registry key. Might make life a little bit easier... On Thu, Jul 21, 2016 at 9:17 AM, David McSpadden wrote: > I have this query: > > SELECT DISTINCT > > sys1.[NetBIOS_name0] , > > ip.IP_Addresses0, > > sys1.User_Name0

[mssms] Query help

2016-07-21 Thread David McSpadden
I have this query: SELECT DISTINCT sys1.[NetBIOS_name0] , ip.IP_Addresses0, sys1.User_Name0, REG.Value0 FROM [CM_SC1].[dbo].[v_r_system] sys1 join CM_SC1.dbo.v_RA_System_IPAddresses ip on ip.ResourceID=sys1.ResourceID join CM_SC1.dbo.v_GS_Registry_Values0 REG on REG.ResourceID=sys1.ResourceID

[mssms] Query Help

2016-06-01 Thread Brian McDonald
Hello, Management has provided me a list of applications they're researching and would like to know which devices have these applications have. Is there a SQL query I could use as a template and re-use it by modifying the DisplayName? For example, one of the apps in question is 'AOL Toolbar'.