Reports filtered to Domain

[Cooldood]

We are running a hybrid AD.  Older machines are AD joined. newer AutoPilot Azure.  

When I look at a user it will show last PCs logged into.  AD and Azure machines.  When I run a report for last login I only get AD machine logins.  I assume this is filtered on domain since AD machine are our company domain.  Azure machines are "WORKGROUP".  Any way to work around this?

[Cooldood]

Ok last post and moving on until I here more infromation.

If I use these three tables I get the logon information I need but I do not know how to filter only users who have not logged in for 30 days

[Cooldood]

If I look at the dashboard all machines show.  If I run any report, it only shows AD machines

[Cooldood]

Select Top 1000000 tblADusers.Username,
tblADusers.Office,
tblADObjects.sAMAccountName As ManagerName,
tblADusers.email As Email,
tblADusers.IsEnabled,
tblADusers.Fax,
tblADusers.LastLogon
From tblADusers
Left Join tblADObjects On
tblADObjects.ADObjectID = tblADusers.ManagerADObjectId
Where tblADusers.email <> 'Blank' And tblADusers.IsEnabled = 'True' And
tblADusers.Fax Is Null And tblADusers.LastLogon < GetDate() - 30
Order By tblADusers.Username

[brandon_jones]

Can you please post the report here? I may be able to help.

[Cooldood]

I did post the query here.  Is that enough?