Browse by Tags

Adding total HDD and RAM size Part 2
Monday, February 11, 2013 8:41 AM
For full details, please see SELECT DISTINCT CS.Name0, CASE WHEN ES.ChassisTypes0 in ( '3' , '4' , '6' , '7' , '15' ) THEN 'Desktop' WHEN ES.ChassisTypes0 in ( '8' , '9' , '10' , '21'... Read More...
Adding Ram and HD
Friday, February 08, 2013 5:32 PM
  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' , BIOS.SerialNumber0, CS.Manufacturer0, CS.Model0... Read More...
Microsoft True Up Report
Thursday, February 07, 2013 8:24 AM
For full details please see =   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.ResourceID WHERE fcm.CollectionID = @CollID AND (Publisher0... Read More...
List Collection Membership
Tuesday, January 22, 2013 8:18 AM
For full details, please see select C.Name from dbo.v_FullCollectionMembership FCM join dbo.v_Collection C on C.CollectionID = FCM.CollectionID Where FCM.Name = 'Gartek-DC' Read More...
PC Serial Number by OU.
Wednesday, January 16, 2013 9:37 PM
For full details, please see 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 R.ResourceID = OU.ResourceID INNER JOIN dbo.v_GS_PC_BIOS AS... Read More...
WMI query for C: with more than 1GB of HD space.
Friday, January 11, 2013 8:39 AM
For full details, please see   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 Read More...
Finding all PCs without Symantec AV installed
Sunday, January 06, 2013 12:04 PM
For Full detail see   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 OS on OS.ResourceID = R.ResourceID JOIN... Read More...
File not in a list
Friday, December 28, 2012 1:57 PM
For full detail , please see select SF.* from dbo.v_GS_SoftwareFile SF Where FileName not in ( 'sol.exe' , 'freecell.exe' ) and FileName like '%.exe' Read More...
Input string was not in a correct format.
Wednesday, December 26, 2012 11:02 AM
  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. Read More...
How to Add Blank Columns to a report.
Saturday, December 08, 2012 11:04 AM
For full details please see: SELECT DISTINCT CS.Name0 as 'PC' , '' as 'Blank column1' , BIOS.SerialNumber0 as 'SN #' , CS.Manufacturer0 as 'Manufacturer' , CS.Model0 as 'Model' , '' as 'Blank column2' , OS.Caption0 as 'OS'... Read More...
Count of how often clients report HW inventory
Wednesday, December 05, 2012 9:03 AM
For full detail see.     I liked this request, I might ever try to make an NICE SSRS report out of this one. But not for a few weeks, so here you go.   select CS.Name0 as 'PC' , Count(HLD.ResourceID)+1 as 'HW inv' from... Read More...
Asset Information with User Full name
Wednesday, November 21, 2012 8:43 AM
For full details please see:     select distinct R.ResourceID, R.User_Name0, R.Netbios_Name0 AS 'Computer_Name' , R.Resource_Domain_OR_Workgr0 AS 'Domain_workgroup' , S.SiteName as 'SMSSiteName' , OS.Caption0 AS 'OperatingSystem'... Read More...
Software by OU
Thursday, October 18, 2012 10:24 AM
SELECT ARP.DisplayName0, Count (*) AS 'Count' , ARP.Publisher0, ARP.Version0 FROM dbo.v_Add_Remove_Programs ARP join dbo.v_RA_System_SystemOUName OU on OU.ResourceID = ARP.ResourceID WHERE OU.System_OU_Name0 = @OU GROUP BY ARP.DisplayName0, ARP.Publisher0, ARP.Version0 ORDER BY ARP.Publisher0, ARP.Version0 Read More...
IE7 Collection
Monday, October 08, 2012 2:17 PM
For full detail please see forum post   select * from SMS_R_System left join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId left join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.ProdID = "ie7"... Read More...
Four reports to answer questions within the reporting forums
Tuesday, September 18, 2012 3:45 PM
So I have been running with my head cut of these days but I always like to make sure that the Reporting forum questions are answer...   For more detail about each of the post see: Read More...
More Posts « Previous page - Next page »

This Blog