myITforum and Windows IT Pro Forums

 Primary User Custom Report

Author Message
gdeguire

  • Total Posts : 231
  • Scores: 0
  • Reward points : 23450
  • Joined: 10/20/2004
  • Status: offline
Primary User Custom Report Thursday, July 22, 2010 3:48 PM (permalink)
0
I am looking for a report that will show me the Primary user (dont care about other users - just that ID with the most console login/console time in order for SCCM to determine that person as the primary user) for each machine in the corporation.

Currently, this is about 28,000 machines so I would like one listing for each 'puter with the ID of the user that is more than likely the 'primary' user.

Anyone have something like this already created? 

OR

Is this not possible?I know its based on event log info but I am not sure where that info is stored...


Thanks.

 
#1
    cnackers

    • Total Posts : 1437
    • Scores: 63
    • Reward points : 44970
    • Joined: 9/22/2006
    • Location: Madison, WI
    • Status: offline
    Re:Primary User Custom Report Thursday, July 22, 2010 4:32 PM (permalink)
    0
    If you have asset intelligence enabled, then the Top Console User is exactly what you are looking for.
    My Blog
    Follow me on Twitter
    Microsoft MVP - System Center Configuration Manager
    Most Valued Community Contributor - 2011



     
    #2
      gdeguire

      • Total Posts : 231
      • Scores: 0
      • Reward points : 23450
      • Joined: 10/20/2004
      • Status: offline
      Re:Primary User Custom Report Thursday, July 22, 2010 4:36 PM (permalink)
      0
      I did not see a Top Console user report but what I did do and, ideally, should have done ahead of posting, was take the 'Hardware 05A - Console Users on a Specific computer' report from Asset Intelligence and customize it as needed with Joins to other views. 

      Is this the report you meant?
       
      #3
        cnackers

        • Total Posts : 1437
        • Scores: 63
        • Reward points : 44970
        • Joined: 9/22/2006
        • Location: Madison, WI
        • Status: offline
        Re:Primary User Custom Report Thursday, July 22, 2010 4:47 PM (permalink)
        0
        Yeah, you would probably want a custom report... 

        here's the first one i found that i wrote that had top console user in it, this shows a whole bunch of details for the computers in your environment...  basically, you want to look at v_GS_SYSTEM_CONSOLE_USAGE (TopConsoleuser0) and then add whatever else you want to see... 

        Select Distinct B.Netbios_Name0, C.Manufacturer0, Model0, F.SerialNumber0 as 'BIOS Serial', 
        G.SerialNumber0 as 'Enclosure Serial', TotalPhysicalMemory0/1024 AS 'Memory (MB)', 
        e.Name0 AS 'Processor Name', E.MaxClockSpeed0 AS 'Processor (GHz)', E.ProcessorType0 as 'Processory Type',
        B.User_Name0 AS 'Last Logged on User', TopConsoleUser0, H.Size0 AS 'Disk Space (MB)', H.FreeSpace0 AS 'Free Disk Space (MB)',
        B.Operating_System_Name_and0 as 'Operating System', J.CSDVersion0 as 'Service Pack Level'

        from dbo.v_r_system B
        join dbo.v_gs_computer_system C on C.ResourceID = B.ResourceID
        join dbo.v_gs_x86_pc_memory D on D.resourceID = B.ResourceID
        join dbo.v_gs_processor E on E.resourceID = D.ResourceID
        join dbo.v_gs_pc_bios F on F.ResourceID = E.ResourceID
        join dbo.v_gs_system_enclosure G on G.ResourceID = F.ResourceID
        join dbo.v_gs_logical_disk H on H.ResourceID = G.ResourceID
        join dbo.v_GS_SYSTEM_CONSOLE_USAGE I on I.ResourceID = H.ResourceID
        join dbo.v_GS_OPERATING_SYSTEM J on J.ResourceID = I.ResourceID

        My Blog
        Follow me on Twitter
        Microsoft MVP - System Center Configuration Manager
        Most Valued Community Contributor - 2011



         
        #4
          wsoutherland

          • Total Posts : 91
          • Scores: 6
          • Reward points : 4930
          • Joined: 9/26/2003
          • Location: North Carolina
          • Status: offline
          Re:Primary User Custom Report Friday, July 23, 2010 4:21 AM (permalink)
          0
          For these reports to work, you have to make sure Audit account logon events is enabled and monitoring for success events.  Your AD Administrator should have this in the Default Domain Policy.  In the security log, its looking mostly for event ID 4624 with a logon type of 2.  Below is a simple report with just the computer name and the primary console user:

          select sys.Name0, console.TopConsoleUser0, wkstat.LastHWScan
          from v_R_system sys
          left join
          v_GS_System_Console_Usage console on
          sys.ResourceID = console.ResourceID
          inner join
          v_GS_Workstation_status wkstat on
          sys.ResourceID = wkstat.ResourceID


          The above report uses a left join for Console Usage, so you will see blanks beside the computers where the console user can't be determined.  It includes the last hardware inventory date, so it will only show machines that have run a hardware inventory.
           
          #5
            Online Bookmarks Sharing: Share/Bookmark

            Jump to:

            Current active users

            There are 0 members and 22 guests.

            Icon Legend and Permission

            • New Messages
            • No New Messages
            • Hot Topic w/ New Messages
            • Hot Topic w/o New Messages
            • Locked w/ New Messages
            • Locked w/o New Messages
            • Read Message
            • Post New Thread
            • Reply to message
            • Post New Poll
            • Submit Vote
            • Post reward post
            • Delete my own posts
            • Delete my own threads
            • Rate post

            2000-2014 ASPPlayground.NET Forum Version 3.9