in

myITforum.com
All Tags » Code (RSS)

Browse by Tags

  • List all non-DHCP NICs

    SELECT CS.Name0, NA.Name0, NAC.IPAddress0, NAC.DefaultIPGateway0, NAC.IPSubnet0, NAC.DNSHostName0 FROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_NETWORK_ADAPTER NA, dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC WHERE NAC.ResourceID = CS.ResourceID AND NA.ResourceID = CS.ResourceID AND NA.ServiceName0 = NAC.ServiceName0...
    Posted to Garth's Blog (Weblog) by Anonymous on 09-09-2008
    Filed under: ConfigMGr, SMS, Code, SQL

  • IP History

    SELECT CS.Name0, HNAC.TimeStamp, HNAC.DefaultIPGateway0, HNAC.DHCPServer0, HNAC.DNSDomain0, HNAC.DNSHostName0, HNAC.IPAddress0, HNAC.IPSubnet0, HNAC.MACAddress0, HNAC.ServiceName0 FROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_HS_NETWORK_ADAPTER_CONFIGUR HNAC WHERE HNAC.ResourceID = CS.ResourceID and HNAC.DHCPEnabled0...
    Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 09-24-2008
    Filed under: ConfigMGr, SMS, Code, SQL

  • WQL - PCs with more that 2 GB free on C:

    select distinct SMS_R_System.Name, SMS_G_System_LOGICAL_DISK.* from SMS_R_System inner join SMS_G_System_LOGICAL_DISK on SMS_G_System_LOGICAL_DISK.ResourceID = SMS_R_System.ResourceId where SMS_G_System_LOGICAL_DISK.FreeSpace > 2048 and SMS_G_System_LOGICAL_DISK.DeviceID = "C:" order by...
    Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 09-24-2008
    Filed under: ConfigMGr, SMS, Code, WQL

  • Resently Installed Programs

    SELECT CS.Name0, CS.UserName0, ISW.ProductName0, ISW.VersionMajor0, ISW.VersionMinor0, ISW.Publisher0, ISW.RegisteredUser0, ISW.InstallDate0, ISW.InstallSource0 FROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_INSTALLED_SOFTWARE ISW WHERE ISW.ResourceID = CS.ResourceID ORDER BY ISW.InstallDate0 DESC, CS.Name0...
    Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 09-25-2008
    Filed under: ConfigMGr, SMS, Code, SQL

  • List PSTs

    SELECT CS.Name0, CS.UserName0, SF.FileName, SF.FileSize, SF.FileModifiedDate, SF.FilePath FROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_SoftwareFile SF, dbo.v_GS_SYSTEM SYS WHERE SYS.ResourceID = CS.ResourceID AND SF.ResourceID = CS.ResourceID AND SYS.SystemRole0='Workstation' AND SF.FileName Like...
    Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 10-06-2008
    Filed under: ConfigMGr, SMS, Code, SQL

  • Exclude this software ...

    select distinct R.Netbios_Name0, R.User_Name0, R.AD_Site_Name0, R.Active0, R.Client0, R.Obsolete0, ARP.DisplayName0, ARP.Version0, R.Operating_System_Name_and0 from v_R_System R inner join v_GS_ADD_REMOVE_PROGRAMS ARP on ARP.ResourceID = R.ResourceId where ARP.DisplayName0 like 'AutoCAD%' or...
    Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 10-19-2008
    Filed under: ConfigMGr, SMS, Code, SQL

  • Find everyone with two or more workstations

    SELECT CS.UserName0 Into #tmp FROM dbo.v_GS_Computer_system CS group by CS.UserName0 Having Count(CS.UserName0) > 1 SELECT CS.Name0, CS.Manufacturer0, CS.Model0, CS.UserName0 FROM dbo.v_GS_Computer_system CS, #tmp Where #tmp.UserName0 = CS.UserName0 or CS.UserName0 != Null Order by CS.UserName0, CS...
    Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 10-28-2008
    Filed under: ConfigMGr, SMS, Code, SQL

  • Creating Custom Reports by Using Configuration Manager 2007 SQL Views

    The Creating Custom Reports by Using Configuration Manager 2007 SQL Views documentation is out. This documentation provides the information to help you create custom reports, determine which Configuration Manager 2007 SQL views contain the information you need for your reports, and identify the path...
    Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 10-30-2008
    Filed under: Code, SQL

  • OU Count of PCs not reporting within 1 day

    SELECT OU.System_OU_Name0, count(*) as 'Count' FROM dbo.v_GS_WORKSTATION_STATUS as WS, dbo.v_R_System as SYS, dbo.v_RA_System_SystemOUName as OU Where SYS.ResourceID = OU.ResourceID and SYS.ResourceID = WS.ResourceID and Datediff(dd,WS.LastHWScan, getdate()) > 1 group by OU.System_OU_Name0...
    Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 11-01-2008
    Filed under: ConfigMGr, SMS, Code, SQL

  • One reason to use network discovery

    Are you wanting to know how to determine which PCs within your environment have vPro? Well you will need to turn on Network Discovery to add this information to your db. http://technet.microsoft.com/en-ca/library/cc431387.aspx Here is the SQL query to tell you. Select * from v_R_System where AMTStatus0...
    Posted to Garth Jones at myITforum.com (Weblog) by Anonymous on 11-13-2008
    Filed under: ConfigMGr, Code, SQL
Page 2 of 18 (177 items) < Previous 1 2 3 4 5 Next > ... Last ยป
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems