Browse by Tags

All Tags » System Center (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: , , , , , , ,
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: , , , ,
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: , , , , , , , , , , , , , ,
Report Two items from Add/Remove Program
Tuesday, December 20, 2011 7:00 PM
Select Name0 From dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_FullCollectionMembership FCM on CS.ResourceID = FCM.ResourceID Where CS.ResourceId in ( select ARP.ResourceId from dbo.v_Add_Remove_Programs ARP Where ARP.Displayname0 = ' Windows Server 2003 Service Pack 2 ') and CS.ResourceId in ( select ARP.ResourceId from dbo.v_Add_Remove_Programs ARP Where... 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: , , , , ,
Two Software Titles
Wednesday, October 19, 2011 10:47 PM
SELECT DISTINCT a.Netbios_Name0 AS 'Computer Name' , CASE WHEN ARP.OMSA IS NULL THEN 'N/A' ELSE ARP.OMSA END AS 'Dell OMSA Version' , CASE WHEN ARP.Equallogic IS NULL THEN 'N/A' ELSE ARP.Equallogic END AS 'Broadcom Version' FROM v_R_System_Valid a INNER JOIN v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = a.ResourceID INNER... 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: , , , ,
PC Var data
Sunday, August 28, 2011 4:38 PM
select Name , Value , Masked from MEP_MachineVariables where MachineID = 63 Read More...
by Garth Jones
Filed under: , , , , , ,
RAM by User name
Saturday, August 06, 2011 2:00 PM
SELECT Distinct SYS.Netbios_Name0 , SYS.Operating_System_Name_and0 , MEM . TotalPhysicalMemory0 / 1024 As C083 FROM v_R_System SYS JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM . ResourceID WHERE User_Name0 = 'Garth' Read More...
by Garth Jones
Filed under: , , , , , ,
Modified version of “Hardware 03B - Computers for a specific primary console user”
Wednesday, June 08, 2011 7:19 AM
Select D istinct R . Netbios_Name0 AS 'Computer Name' , SCU . SystemConsoleUser0 as 'User' , S . SiteName as 'SMS Site Name' , SEU . SerialNumber0 AS 'Serial Number' , SEU . SMBIOSAssetTag0 AS 'Asset Tag' , CS . Manufacturer0 AS 'Manufacturer' , CS . Model0 AS 'Model' , SCU . NumberOfConsoleLogons0 AS 'Console... Read More...
by Garth Jones
Filed under: , , , , , ,
Server by Collection
Friday, May 06, 2011 8:10 AM
select Distinct CS . Name0 , CS . Domain0 , OS . Caption0 From dbo . v_GS_COMPUTER_SYSTEM CS join dbo . v_GS_OPERATING_SYSTEM OS on CS . ResourceID = OS . ResourceID join dbo . v_GS_SYSTEM S on CS . ResourceID = S . ResourceID join dbo . v_FullCollectionMembership FCM on CS . ResourceID = FCM . ResourceID Where S . SystemRole0 = 'Server' and FCM . CollectionID... Read More...
by Garth Jones
Filed under: , , , ,
Canadian Microsoft Management Summit 2011
Monday, May 02, 2011 8:58 AM
Did you miss MMS this year? Well here is you change to see the highlight! (aka Put your head in the cloud)   When: Friday, May 6 Where: Microsoft Canada Headquarters in Mississauga, Ontario Registration Details: http://www.microsoft.com/canada/events/event_details.aspx?event_id=1032484234 Read More...
by Garth Jones
Filed under: , , , , , , , , , , , , , ,
Query Logic
Monday, May 02, 2011 8:01 AM
SELECT SYS.Netbios_Name0 , SF . FileName , SF . FileSize / 1024 / 1024 AS 'Size, KB' , SF . FilePath FROM dbo . v_GS_SoftwareFile AS SF INNER JOIN dbo . v_R_System AS SYS ON SYS.ResourceID = SF . ResourceID where ( SF . FileName LIKE '%.pdf' AND SF . FilePath LIKE '%My Documents%' ) OR ( SF . FileName LIKE '%.pdf' AND SF . FilePath... Read More...
by Garth Jones
Filed under: , , ,
Talk TechNet: take a ways
Friday, April 22, 2011 2:29 PM
As promised here are a few good resource to help you with ConfigMgr. ConfigMgr focused websites http://www.myitforum.com/ http://faqshop.com/ Mailing list http://www.myitforum.com/absolutenm/EmailLists.aspx Forums http://faqshop.com/forums/ http://www.myitforum.com/forums/ http://social.technet.microsoft.com/Forums/en-ca/category/configurationmanager Blogs http... Read More...
by Garth Jones
Filed under: , , , ,
More Posts Next page »
Go

This Blog

Syndication