$Test. $Test = Get-LansweeperReport -SqlInstance "LANSWEEPER.AD.EVOTEC.XYZ" -Report WindowsAutomaticUpdateSettingsAudit,MicrosoftPatchTuesdayAuditJuly2019 Or $Test = Get-LansweeperReport -SqlInstance "LANSWEEPER.AD.EVOTEC.XYZ" -Report WindowsAutomaticUpdateSettingsAudit Get-LansweeperReport -SqlInstance "LANSWEEPER.AD.EVOTEC.XYZ" -Report InstalledWindowsUpdates | Format-Table -Autosize Sorry I get what you want now,sorry, I believe you need the table tblCPlogoninfo, you may need to add additional filters as there will be lots of results, but this will return all assets and all Users logged on with each logon date Select Top 1000000 tblassets.AssetName, tblassets.AssetID, ts. The list only shows the last login for each computer. Usage Get-LansweeperReport -SqlInstance "LANSWEEPER.AD.EVOTEC.XYZ" -Report SoftwareLicenseKeyOverview | Format-Table -Autosize I have modified the page that shows the user information, to include a list of the computers that the user has logged on to. It's a really small project (about 80 lines of code) but you can get lots of ready to go reports.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |