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

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)