Browse by Tags

All Tags » ConfigMGr (RSS)
PC not logon for 14 days.
Monday, February 06, 2012 9:04 PM
For full details see. http://social.technet.microsoft.com/Forums/en-US/configmgrsdk/thread/cf7d80a0-1a7c-430c-b33a-ee47a0efa806   select CS.Name0, LCU. date From dbo.v_GS_COMPUTER_SYSTEM CS join ( Select ResourceID, max (LastConsoleUse0) as ' date ' from dbo.v_GS_SYSTEM_CONSOLE_USER SCU Group by ResourceID) as LCU on CS.ResourceID = LCU.ResourceID... Read More...
by Garth Jones
Filed under: , , , , , , ,
SCCM Query for Memory & CPU
Tuesday, January 31, 2012 9:18 PM
See Forum post for fill details. select distinct SMS_R_System.Name, SMS_R_System.Client, SMS_R_System.LastLogonUserName, SMS_R_System.ADSiteName, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory, SMS_G_System_PROCESSOR.NormSpeed from SMS_R_System inner join SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId left join SMS_G_System_PROCESSOR... Read More...
by Garth Jones
Filed under: , , , , ,
Custom Windows 7 report - workstation manufacturer & model & client version
Monday, January 16, 2012 8:21 PM
SELECT DISTINCT COMSYS.Manufacturer0, COMSYS.Model0, Client.Version0, Count (*) FROM v_GS_COMPUTER_SYSTEM COMSYS JOIN v_FullCollectionMembership fcm ON COMSYS.ResourceID = FCM.ResourceID JOIN v_GS_PROCESSOR PROC 1 ON COMSYS.ResourceID = PROC 1.ResourceID JOIN v_GS_X86_PC_MEMORY MEM ON COMSYS.ResourceID = MEM.ResourceID JOIN v_GS_OPERATING_SYSTEM OPSYS ON COMSYS... Read More...
by Garth Jones
Filed under: , , , ,
Custom Windows 7 report - workstation manufacturer & model type
Monday, January 16, 2012 6:03 PM
SELECT DISTINCT COMSYS.Manufacturer0, COMSYS.Model0, Count (*) FROM v_GS_COMPUTER_SYSTEM COMSYS JOIN v_FullCollectionMembership fcm ON COMSYS.ResourceID = FCM.ResourceID JOIN v_GS_PROCESSOR PROC 1 ON COMSYS.ResourceID = PROC 1.ResourceID JOIN v_GS_X86_PC_MEMORY MEM ON COMSYS.ResourceID = MEM.ResourceID JOIN v_GS_OPERATING_SYSTEM OPSYS ON COMSYS.ResourceID = OPSYS... Read More...
by Garth Jones
Filed under: , , , ,
WQL Query for both x86 and x64 version of Software
Monday, January 16, 2012 5:27 PM
  select distinct SMS_R_System.Name, SMS_R_System.ResourceId from SMS_R_System where SMS_R_System.ResourceId in ( select SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = " Microsoft Lync 2010 ") or SMS_R_System.ResourceId in ( select SMS_G_System_ADD_REMOVE_PROGRAMS_64... Read More...
by Garth Jones
Filed under: , , , ,
Adding IP address to Client Summary data
Friday, January 13, 2012 8:49 AM
select NetBiosName as " CAM NetBiosName ", LastPolicyRequest as " CAM LastPolicyRequest ", LastDDR as " CAM LastDDR ", sy.Operating_System_Name_and0 as " Operating System ", sy.Resource_Domain_OR_Workgr0 as " AD Domain ", NAC.IPAddress0 from v_CH_ClientSummary inner join v_R_System as sy on sy.ResourceID=MachineID... Read More...
by Garth Jones
Filed under: , , , ,
WINS/DNS for a Collection
Friday, January 13, 2012 8:41 AM
SELECT S.Name0 AS [System Name], OS.Caption0 AS [Operating System], OS.CSDVersion0 AS [Service Pack], OS.InstallDate0 AS [Original OS Install Date ], OS.LastBootUpTime0 AS [ Last Boot Time ], NAC.IPAddress0 AS [IP Address], NAC.IPSubnet0 AS [Subnet Mask], NAC.DefaultIPGateway0 AS [Gateway], NAC.DNSServerSearchOrder0 AS [DNS Servers], NAC.WINSPrimaryServer0 AS... Read More...
by Garth Jones
Filed under: , , ,
MyITforum donation for 2012
Monday, January 02, 2012 10:21 AM
With the start of a new year, it is that time again to support the System Center Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). http://myitforum.com/myitforumwp/aboutus/donations/   MIF is truly a community that helps each other both professionally and personally. But it cost thousands of dollars each MONTH to... Read More...
by Garth Jones
Filed under: , , , , , , , , , , , , , ,
Query on Prohibited application for specific OU
Monday, November 28, 2011 8:39 AM
Select distinct ou.system_ou_name0, sys.Netbios_Name0, fcm.SiteCode,sys.User_Domain0, sys.User_Name0, -- DATEADD(mi,(usr.lastLogontimeStamp0 / 600000000) - 157258080,0) AS [Last Logon Time Stamp (UTC)], usr.company0, sys.Operating_System_Name_and0, Displayname0, Version0, InstallDate0 FROM dbo.v_R_System sys JOIN dbo.v_r_User usr on SYS.user_name0 = usr.user_name0... Read More...
by Garth Jones
Filed under: , , ,
Query to find multiple Net bois names on single IP
Thursday, November 24, 2011 8:51 AM
http://social.technet.microsoft.com/Forums/en-US/configmgrai/thread/c23b6c8f-57a7-4bdf-932e-e28060d4323d select CS.Name0, NAC.IPAddress0 from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC on CS.ResourceID = NAC.ResourceID Where NAC.IPAddress0 != '' Group by CS.Name0, NAC.IPAddress0 Having count (NAC.IPAddress0) > 1 .csharpcode... Read More...
by Garth Jones
Filed under: , , , , ,
Don’t you love emails like this one!
Monday, November 14, 2011 10:21 PM
I left ITProTeach (DevTeach) a bit early so that I could head home to pack before my long overdue vacation! After getting back, I found this nice surprise in my inbox!   If you want to download the PPT, you can find it in Enhansoft’s blog http://support.enhansoft.com/Blogs/post/Diving-Deep-in-the-SCCM-data!-Bring-your-Swim-trunks!-e28093-Part-2.aspx http... Read More...
by Garth Jones
Filed under: , , , , ,
Advertisements, Programs and Main User of all PC
Saturday, October 01, 2011 10:16 AM
SELECT A . AdvertisementName , A . ProgramName , R . Netbios_Name0 as Computername , SCUM . TopConsoleUser0 as MainUsername FROM dbo . v_R_System_Valid R join dbo . v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM on R . ResourceID = SCUM . ResourceID join dbo . v_ClientAdvertisementStatus CAS on R . ResourceID = CAS . ResourceID join dbo . v_Advertisement A on A . AdvertisementID... Read More...
by Garth Jones
Filed under: , , , , ,
Serial Number, User Information and installation dates of the software
Wednesday, September 28, 2011 6:28 PM
SELECT adv . AdvertisementName , stat . LastStateName , adv . Comment AS C072 , pkg . Name AS C062 , adv . ProgramName AS C071 , adv . SourceSite , adv . AdvertisementID , se . SerialNumber0 , cs . UserName0 , Stat . LastAcceptanceStatusTime FROM v_Advertisement adv JOIN v_Package pkg ON adv . PackageID = pkg . PackageID JOIN v_ClientAdvertisementStatus stat... Read More...
by Garth Jones
Filed under: , , , , ,
10b–adding top console user
Sunday, September 18, 2011 1:13 PM
if ( @SoftwareID = '' ) set @SoftwareID = NULL; if ( @Tag1Name = '' ) set @Tag1Name = NULL; if ( @Tag2Name = '' ) set @Tag2Name = NULL; if ( @Tag3Name = '' ) set @Tag3Name = NULL; select MEM . Netbios_Name0 [Computer Name] , SCUM . TopConsoleUser0 as 'TCU' , Soft . NormalizedName [Product Name] , TG1 . TagName [Label 1... Read More...
by Garth Jones
Filed under: , ,
Query to fetch the machines from a specific OU with the Specific Machine Model
Tuesday, September 13, 2011 7:41 AM
Select R . Name0 From dbo . v_R_System R join dbo . v_GS_COMPUTER_SYSTEM CS on R . ResourceID = CS . ResourceID join dbo . v_RA_System_SystemOUName OU on R . ResourceID = OU . ResourceID Where CS . Model0 = 'Virtual Machine' Group by R . Name0 , CS . Model0 Having max ( OU . System_OU_Name0 ) = 'GARTEK.TST/WORKSTATIONS' Read More...
by Garth Jones
Filed under: , , , ,
More Posts Next page »
Go

This Blog

Syndication