ingram59 Posted June 12, 2013 Report post Posted June 12, 2013 I've read prior solutions to find the "last logged in user". That's not what I need here. I'm needing to build a query in SCCM (if possible) that will show me all the computers that specific ID's have been logged in to, where I provide those user id's I DON'T simply need the Last Login information. I need to show all the machines that the users were logged in to. I don't need their login dates and times. I just need to return all the computer names for the user id's in question. Is there a way to do this using SCCM Queries? There are four id's that I'm targeting. Thanks in advance for your assistance Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted June 18, 2013 Report post Posted June 18, 2013 If you have user AI enabled this will do the trick. select CS.Name0, SCU.LastConsoleUse0 from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_SYSTEM_CONSOLE_USER SCU on CS.ResourceID = SCU.ResourceID where SCU.SystemConsoleUser0 = <Userid> Quote Share this post Link to post Share on other sites More sharing options...
