Notification

Icon
Error

Report - Request

Posted: Friday, August 14, 2020 8:05:31 PM(UTC)
nyra_mtobias

nyra_mtobias

Member Original PosterPosts: 2
0
Like
I am looking for the following report, but to include OS.

If possible to include Processor.

Thanks!
Brandon
#1Brandon Member Posts: 43  
posted: 8/18/2020 8:21:07 PM(UTC)
Which report are you looking for?
nyra_mtobias
#2nyra_mtobias Member Original PosterPosts: 2  
posted: 8/19/2020 4:20:54 PM(UTC)
Similar to the following.

https://www.lansweeper.c...ging-into.aspx#post44201

Including OS and Processor.
RC62N
#3RC62N Member Posts: 470  
posted: 8/19/2020 5:03:40 PM(UTC)
Add the extra elements to SubQuery3, where the other asset properties are being retrieved.
Code:
Select Top 1000000
  tblADusers.Username,
  tblADusers.Userdomain,
  SubQuery2.Count As UniqueComputers,
  SubQuery3.AssetID,
  SubQuery3.AssetName,
  SubQuery3.OSname,
  SubQuery3.Version,
  SubQuery3.Processor,
  SubQuery3.Domain,
  SubQuery3.IPAddress,
  SubQuery3.LastLogon
From tblADusers
  Left Join (Select Top 1000000
               SubQuery1.Username,
               SubQuery1.Userdomain,
               Count(SubQuery1.AssetID) As Count
             From (Select Distinct Top 1000000
                     tblCPlogoninfo.Username,
                     tblCPlogoninfo.Domain As Userdomain,
                     tblAssets.AssetID
                   From
                     tblCPlogoninfo
                     Inner Join tblAssets On tblAssets.AssetID = tblCPlogoninfo.AssetID) SubQuery1
             Group By
               SubQuery1.Username,
               SubQuery1.Userdomain) SubQuery2 On SubQuery2.Username = tblADusers.Username
                                              And SubQuery2.Userdomain = tblADusers.Userdomain
  Left Join (Select Top 1000000
               tblCPlogoninfo.Username,
               tblCPlogoninfo.Domain As Userdomain,
               tblAssets.AssetID,
               tblAssets.AssetName,
               tsysOS.OSname,
               tblAssets.Version,
               tblAssets.Processor,
               tblAssets.Domain,
               tblAssets.IPAddress,
               Max(tblCPlogoninfo.logontime) As LastLogon
             From
               tblCPlogoninfo
               Inner Join tblAssets On tblAssets.AssetID = tblCPlogoninfo.AssetID
               LEFT JOIN tsysOS ON tsysOS.OScode = tblAssets.OScode
             Group By
               tblCPlogoninfo.Username,
               tblCPlogoninfo.Domain,
               tblAssets.AssetID,
               tblAssets.AssetName,
               tsysOS.OSname,
               tblAssets.Version,
               tblAssets.Processor,
               tblAssets.Domain,
               tblAssets.IPAddress) SubQuery3 On SubQuery3.Username = tblADusers.Username
                                             And SubQuery3.Userdomain = tblADusers.Userdomain
Order By
  tblADusers.Userdomain,
  tblADusers.Username,
  SubQuery3.LastLogon Desc

Active Discussions

Lansweeper Show attached USB devices
by  Dannnnooo   Go to last post Go to first unread
Last post: Today at 10:42:17 AM(UTC)
Lansweeper Lansweeper Ubiquiti AP Bullet Devices
by  Beta_Tester  
Go to last post Go to first unread
Last post: Today at 8:59:06 AM(UTC)
Lansweeper Report to find ScanServer 'not working'
by  Rocher Vincent   Go to last post Go to first unread
Last post: Today at 8:07:26 AM(UTC)
Lansweeper Security: HSTS Missing
by  Grey  
Go to last post Go to first unread
Last post: Yesterday at 9:36:49 PM(UTC)
Lansweeper Include custom ticket fields as email tags
by  brownscar   Go to last post Go to first unread
Last post: 9/29/2020 4:09:02 PM(UTC)
Lansweeper SSH - Keyboard Interactive Authentication
by  blackmoonwolf  
Go to last post Go to first unread
Last post: 9/29/2020 1:21:59 PM(UTC)
Lansweeper Lansweeper Dark Theme
by  blackmoonwolf   Go to last post Go to first unread
Last post: 9/29/2020 1:18:32 PM(UTC)
Lansweeper Drag and Drop Email
by  Chris Durham  
Go to last post Go to first unread
Last post: 9/29/2020 7:13:09 AM(UTC)