in

SMSUG.ca

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

Browse by Tags

  • Query to report OU information for Machines

    For full details please see: http://www.myitforum.com/forums/query-to-report-OU-information-for-Machines-m235317.aspx   select R.Name0, max (OU.System_OU_Name0) From dbo.v_R_System R join dbo.v_RA_System_SystemOUName OU on OU.ResourceID = R.ResourceID join dbo.v_FullCollectionMembership FCM on FCM...
    Posted to Garth Jones (Weblog) by Garth on 04-05-2012
  • Last Reboot Report

    For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/e0147d8a-8946-42bb-b6ed-a3c92bae5b23   select distinct R.ResourceID, R.Netbios_Name0 AS ' Computer Name ', OS.LastBootUpTime0 AS ' Last Boot Time ', R.Resource_Domain_OR_Workgr0 AS '...
    Posted to Garth Jones (Weblog) by Garth on 03-18-2012
  • Lists people and how much they've been using specified software with OU fix

    For full details see: http://www.myitforum.com/forums/tm.aspx?high=&m=234978&mpage=1#234980 select U.Name0 as ' Bruger ', -- U.displayName0 as 'Bruger', MU.FullName as ' Brugernavn ', ou.ou as OU, round( sum (MUS.UsageTime)/60.0,2) as ' Forbrug (min) ' from dbo...
    Posted to Garth Jones (Weblog) by Garth on 03-16-2012
  • Lists people and how much they've been using specified software

    For full details see: http://www.myitforum.com/forums/Need-some-SQL-help-think-its-simple-m234978.aspx select U.Name0 as ' Bruger ', -- U.displayName0 as 'Bruger', MU.FullName as ' Brugernavn ', replace( max (ou.User_OU_Name0),' Gartek.LOCAL/Ottawa/ ',' ') as OU...
    Posted to Garth Jones (Weblog) by Garth on 03-16-2012
  • List collection name and number of resources by OS

    For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/370ceff1-0f54-46f3-8e8e-5459069125e4     SELECT C.Name, OS.Caption0 as ' Operating System ', OS.CSDVersion0 as ' Service Pack ', COUNT (*) AS ' Count ' FROM dbo.v_R_System...
    Posted to Garth Jones (Weblog) by Garth on 03-14-2012
  • 78!

    I have been told that we are 78 people short of the 1200 people for tomorrows Webcast! Will you be the one to help set a new record for myITForm webcast? Sign up now! http://bit.ly/yMimvp   And don’t forget that I have BIG news to spill at the end of the Webcast!
    Posted to Garth Jones (Weblog) by Garth on 03-13-2012
  • Report for matching names

    For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/8bda0fe9-7d80-44d0-9a52-f1f573423abf/   select CS.ResourceID, cs.NAME0, PC2.name0, substring (CS.NAME0,5,LEN(cs.NAME0)) from dbo.v_GS_COMPUTER_SYSTEM CS, ( select CS.ResourceID, cs.NAME0, substring ...
    Posted to Garth Jones (Weblog) by Garth on 03-12-2012
  • Total SQL Server Systems Query

    See forum post for full details: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/51ead03a-a43d-46df-b0ab-059d9322e432   SELECT DISTINCT R.Name0, R.User_Name0, ARP.DisplayName0 AS [Software Name], ARP.Version0 AS [Installed Version], IP.IP_Addresses0 AS IPAddress, -- ARP...
    Posted to Garth Jones (Weblog) by Garth on 03-12-2012
  • Link v_MeteredUser.FullName to a full name from AD v2

    To see full post see http://www.myitforum.com/forums/tm.aspx?high=&m=234899&mpage=1#234905 select R.Netbios_Name0 as ' Computernavn ', -- U.displayName0 as 'Bruger', Full_User_Name0, max (ou.User_OU_Name0), MU.FullName as ' Brugernavn ', MUS.LastUsage as ' Sidst brugt...
    Posted to Garth Jones (Weblog) by Garth on 03-12-2012
  • Link v_MeteredUser.FullName to a full name from ad

    To see the full post http://www.myitforum.com/forums/How-to-link-v_MeteredUserFullName-to-a-full-name-from-ad-m234899.aspx select R.Netbios_Name0 as ' Computernavn ', -- U.displayName0 as 'Bruger', Full_User_Name0, MU.FullName as ' Brugernavn ', MUS.LastUsage as ' Sidst brugt...
    Posted to Garth Jones (Weblog) by Garth on 03-12-2012
Page 2 of 7 (63 items) < Previous 1 2 3 4 5 Next > ... Last »
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems