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 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)