Notification

Icon
Error

A Simple Report (or so I thought) - Looking for a report

Posted: Tuesday, August 4, 2020 11:50:26 PM(UTC)
Jeff Haws

Jeff Haws

Member Original PosterPosts: 1
0
Like
I am just trying to get a report of active computers that include both apple and windows devices and include the email address from the logged in user AD account. I do not see any in the canned reports that works for me.

Anyone have one they can share?
Andy.S
#1Andy.S Member Posts: 29  
posted: 8/5/2020 11:30:45 AM(UTC)
Does this work for you ?

Code:
Select Top 1000000 tblAssets.AssetName,
  tsysAssetTypes.AssetTypename As [Asset Type],
  tblAssets.Domain,
  tsysOS.OSname As [OS name],
  tblADusers.email,
  tblAssetCustom.Manufacturer,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssets.Description
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
  Left Join tblComputerSystemProduct On
    tblAssets.AssetID = tblComputerSystemProduct.AssetID
  Left Join (Select Case
          When tblComputersystem.Domainrole > 1 Then 'Server'
          Else 'Workstation'
        End As type,
        tblComputersystem.AssetID
      From tblComputersystem) tComputersystem On tblAssets.AssetID =
    tComputersystem.AssetID
  Inner Join tblADusers On tblAssets.Username = tblADusers.Username
Where (tsysAssetTypes.AssetTypename Like '%ios%' Or
    tsysAssetTypes.AssetTypename Like '%Windows%') And tblAssetCustom.State = 1
Order By tblAssets.AssetName

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)