Friday 18 December 2009

All Computers with Spotify installed query

All Computers with Spotify installed query:

select SMS_R_System.Name, SMS_R_System.LastLogonUserName from SMS_R_System where SMS_R_System.ResourceId in (select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Spotify") and SMS_R_System.Obsolete = 0 and SMS_R_System.Client = 1 and SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT Workstation%" and SMS_R_System.ResourceDomainORWorkgroup = "DOMAINNAME" and SMS_R_System.Name not in ("MACHINE NAMES","Machine Names")

No comments:

Post a Comment