Month – June 2012

Query for computers with single partition

For full details see: select SMS_R_System.Name from SMS_R_System where SMS_R_System.ResourceId not in ( select SMS_G_System_PARTITION.ResourceId from SMS_G_System_PARTITION where SMS_G_System_PARTITION.DeviceID = “Disk #0, Partition #1” )

List of PCs with Project, Visio or Visual

For full details, please see this forum post. Select sys.Netbios_Name0, sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0, ARP.Version0 FROM v_R_System sys JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID WHERE Displayname0 like ‘%visio%’ or displayname0 like ‘%project%’ or displayname0 like ‘%visual%’