cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Cooldood
Engaged Sweeper II

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?

5 REPLIES 5
Cooldood
Engaged Sweeper II

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_0-1672239370268.png

 

Cooldood
Engaged Sweeper II

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

Cooldood_0-1672230476393.png

 

Cooldood
Engaged Sweeper II

 

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
Champion Sweeper III

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

I did post the query here.  Is that enough?