in

SMSUG.ca

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

Browse by Tags

  • 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
  • How to Add Blank Columns to a report.

    For full details please see: http://www.myitforum.com/forums/SCCM-Report-question-m238232.aspx SELECT DISTINCT CS.Name0 as 'PC' , '' as 'Blank column1' , BIOS.SerialNumber0 as 'SN #' , CS.Manufacturer0 as 'Manufacturer' , CS.Model0 as 'Model' , ''...
    Posted to Garth Jones (Weblog) by Garth on 12-08-2012
  • Last Logon User

    For full details see: http://www.windows-noob.com/forums/index.php?/topic/7022-last-logged-user/   Select R.Netbios_Name0, R.User_Domain0 + '\' + R.User_Name0, CS.UserName0 from dbo.v_R_System R join dbo.v_GS_COMPUTER_SYSTEM CS on R.ResourceID = CS.ResourceID join dbo.v_FullCollectionMembership...
    Posted to Garth Jones (Weblog) by Garth on 12-07-2012
  • Count of how often clients report HW inventory

    For full detail see. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/32c4db2f-ae84-4fed-93c1-c3f35f8a6fff     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'...
    Posted to Garth Jones (Weblog) by Garth on 12-05-2012
  • Asset Information with User Full name

    For full details please see: http://social.technet.microsoft.com/Forums/en-US/configmgrai/thread/107d690a-4bbd-49c4-87bf-389278525b63     select distinct R.ResourceID, R.User_Name0, R.Netbios_Name0 AS 'Computer_Name' , R.Resource_Domain_OR_Workgr0 AS 'Domain_workgroup' , S.SiteName...
    Posted to Garth Jones (Weblog) by Garth on 11-21-2012
  • PC with MAC Address

    For full details see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/6c00b44f-1b92-4c1b-924e-fd79c191d5e9 Select R.Netbios_Name0, MAC.MAC_Addresses0 from dbo.v_R_System R join dbo.v_RA_System_MACAddresses MAC ON R.ResourceID = MAC.ResourceID Where MAC.MAC_Addresses0 in ( SELECT...
    Posted to Garth Jones (Weblog) by Garth on 11-17-2012
  • Softwares installed in last 90 days on a collection of PC

    For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/80c794d7-a55f-4d13-985b-9b84efd6f9e7   SELECT R.Name0 as 'PC' , CS.Manufacturer0 as 'Man' , CS.Model0 as 'Model' , ARP.DisplayName0 as 'DisplayName' , ARP.Version0...
    Posted to Garth Jones (Weblog) by Garth on 11-17-2012
  • Office, Visio, Project with OS name.

    For full details please see: http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/66dbc370-9795-4f98-9193-d8f0bd84830b/ SELECT Distinct R.Name0, ARP.DisplayName0, OS.Caption0 FROM dbo.v_R_System R JOIN dbo.v_ADD_REMOVE_PROGRAMS ARP ON R.ResourceID = ARP.ResourceID Join dbo.v_GS_SYSTEM...
    Posted to Garth Jones (Weblog) by Garth on 11-14-2012
Page 3 of 40 (398 items) < Previous 1 2 3 4 5 Next > ... Last ยป
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems