Month: January 2008

How to find all PCs with a Disk Array

Use this query to find all PCs with a Disk Array   SELECT distinct             v_GS_COMPUTER_SYSTEM.Name0 as ‘PC Name’             , v_GS_COMPUTER_SYSTEM.UserName0 as ‘User Name’   FROM             v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM,             v_GS_DISK v_GS_DISK WHERE             v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_DISK.ResourceID             AND ((v_GS_DISK.Description0=’Disk Array’))

January 17th 2008 User Group Meeting

Upcoming UG Meeting January 17th 2008 User Group MeetingTopic: Overview of System Center Configuration Manager 2007 and review of 1E Products Description: In this joint presentation, Garth Jones will present an overview of System Center Configuration Manager 2007 and Ed Aldrich will present at overview of 1E products. In Garth Jones’ presentation, he will cover what is […]

All Windows XP without SP2

select SMS_R_System.Name, SMS_R_System.SMSAssignedSites, SMS_R_System.IPAddresses, SMS_R_System.IPSubnets, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonUserName, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceId, SMS_R_System.NetbiosName from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion like “%Workstation 5.1%” and (not SMS_G_System_OPERATING_SYSTEM.CSDVersion = “Service Pack 2”)