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 zerologin posted report
by  Antikas   Go to last post Go to first unread
Last post: Today at 9:42:54 AM(UTC)
Lansweeper Report doesn't show empty results for a field
by  AlexMZetec  
Go to last post Go to first unread
Last post: Yesterday at 3:43:08 PM(UTC)
Lansweeper Renamed Pcs / Laptops report
by  RC62N   Go to last post Go to first unread
Last post: Yesterday at 3:36:35 PM(UTC)
Lansweeper Servers without AV Report
by  Elwood472  
Go to last post Go to first unread
Last post: 9/27/2020 2:50:10 AM(UTC)
Lansweeper Adding Group by and Sum to Existing Report
by  RC62N  
Go to last post Go to first unread
Last post: 9/25/2020 3:43:49 PM(UTC)
Lansweeper Custom Fields on Report for Helpdesk Tickets
by  plangham_eurotech   Go to last post Go to first unread
Last post: 9/24/2020 2:43:41 PM(UTC)
Lansweeper September Patch Tuesday
by  Gilles B.  
Go to last post Go to first unread
Last post: 9/24/2020 7:47:49 AM(UTC)