in

SMSUG.ca

...your virtual communITy
All Tags » CM12 (RSS)

Browse by Tags

  • Adding Ram and HD

      SELECT DISTINCT CS.Name0, CASE WHEN ES.ChassisTypes0 in ( '3' , '4' , '6' , '7' , '15' ) THEN 'Desktop' WHEN ES.ChassisTypes0 in ( '8' , '9' , '10' , '21' ) THEN 'Laptop' Else 'Unknown' END as 'Chassis'...
    Posted to Garth Jones (Weblog) by Garth on 02-08-2013
  • Microsoft True Up Report

    For full details please see http://www.myitforum.com/Forums/tm.aspx?m=238674&high =   SELECT distinct DisplayName0, Count (arp.ResourceID) AS 'Count' , Publisher0, @CollID as CollectionID FROM dbo.v_Add_Remove_Programs arp JOIN dbo.v_FullCollectionMembership fcm on arp.ResourceID = fcm...
    Posted to Garth Jones (Weblog) by Garth on 02-07-2013
  • List Collection Membership

    For full details, please see http://www.windows-noob.com/forums/index.php?/topic/7308-collection-membership/#entry27677 select C.Name from dbo.v_FullCollectionMembership FCM join dbo.v_Collection C on C.CollectionID = FCM.CollectionID Where FCM.Name = 'Gartek-DC'
    Posted to Garth Jones (Weblog) by Garth on 01-22-2013
  • PC Serial Number by OU.

    For full details, please see http://www.myitforum.com/forums/Active-Directory-Discovery-additional-Attributes-and-broken-reports-and-queries-m238462.aspx select distinct R.ResourceID, R.Name0, R.Client0, BIOS.SerialNumber0 from dbo.v_R_System AS R LEFT OUTER JOIN dbo.v_RA_System_SystemOUName AS OU ON...
    Posted to Garth Jones (Weblog) by Garth on 01-16-2013
  • WMI query for C: with more than 1GB of HD space.

    For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/fde395bb-a4b6-4347-b1b6-8c180c3f7f46   This is a WMI WQL query and NOT and native CM07 / CM12 WQL query. select Size from Win32_LogicalDisk Where DeviceId="C:" and size > 1073741824
    Posted to Garth Jones (Weblog) by Garth on 01-11-2013
  • Finding all PCs without Symantec AV installed

    For Full detail see http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/547016e0-9f15-4611-aac9-24f582aa0614   select R.netbios_name0, R.user_name0, OS.Caption0 AS 'Operating System' , ES.SerialNumber0 AS 'Serial Number' from dbo.v_R_System R join dbo.v_GS_OPERATING_SYSTEM...
    Posted to Garth Jones (Weblog) by Garth on 01-06-2013
  • List new CM clients within the last 14 days.

    For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/thread/2f072158-88c2-48e9-8125-2e137494fbeb select Creation_Date0, Name0, User_Name0 from dbo.v_R_System where datediff(dd,Creation_Date0, getdate()) < 14 and Client0 = 1
    Posted to Garth Jones (Weblog) by Garth on 12-31-2012
  • How to find all workstations with SNMP.

    For full detail please see, http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/2eb10f29-0927-4b43-a4a4-0c712793673f Select CS.Name0 as 'PC Name' , OS.Caption0 as 'OS' , OS.CSDVersion0 as 'SP' From dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_SERVICE S on CS...
    Posted to Garth Jones (Weblog) by Garth on 12-29-2012
  • File not in a list

    For full detail , please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/688bff46-a0ed-44cb-84c2-df036fe40e84 select SF.* from dbo.v_GS_SoftwareFile SF Where FileName not in ( 'sol.exe' , 'freecell.exe' ) and FileName like '%.exe'
    Posted to Garth Jones (Weblog) by Garth on 12-28-2012
  • Input string was not in a correct format.

      If you are trying to install CM12 console on a workstation, you will receive the following error: Input string was not in a correct format .   The solution is to browse the DVD and smssetup\bin\i386 and execute the AdminConsole.msi.
    Posted to Garth Jones (Weblog) by Garth on 12-26-2012
Page 3 of 6 (51 items) < Previous 1 2 3 4 5 Next > ... Last ยป
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems