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

Action Open Teams/SfB Chat with user
by  marceman   Go to last post Go to first unread
Last post: 9/10/2020 4:10:18 PM(UTC)
Lansweeper Report showing app even after it has gone
by  TimHolmes1973  
Go to last post Go to first unread
Last post: 9/9/2020 11:50:17 PM(UTC)
Action Remote Device Manager
by  steveb   Go to last post Go to first unread
Last post: 9/4/2020 9:52:01 PM(UTC)
Action View Windows Defender detections remotely
by  steveb  
Go to last post Go to first unread
Last post: 9/4/2020 9:37:48 PM(UTC)
Action Remote Uninstaller
by  steveb   Go to last post Go to first unread
Last post: 9/4/2020 9:27:17 PM(UTC)
Lansweeper Filter Assets' groups by WinSystemLocale
by  Alex Beaumier  
Go to last post Go to first unread
Last post: 8/20/2020 4:17:17 PM(UTC)
Action Chrome History
by  csys   Go to last post Go to first unread
Last post: 8/14/2020 2:14:21 PM(UTC)
Action Offer remote assistance
by  FixitDave  
Go to last post Go to first unread
Last post: 8/4/2020 9:57:51 AM(UTC)