Hi,
I m trying to have a specific report with all my workstation included in our Domain (BE-AD.loc) but not only, I want to include all Macintosh (but like you know Macintosh are not member of domain).
- This report need to include workstations (Windows 10 and 8.1) no servers --> Iplocation contain "Office" and Domain contain "BE-AD"
and
- This report need to include all Macintosh -> Iplocation contain "Office" or Assettype : contain "Apple Mac"
I dont know how I can do this kind of report because I m noob in SQL resquest
Thanks Guys for your help.
I m trying to have a specific report with all my workstation included in our Domain (BE-AD.loc) but not only, I want to include all Macintosh (but like you know Macintosh are not member of domain).
- This report need to include workstations (Windows 10 and 8.1) no servers --> Iplocation contain "Office" and Domain contain "BE-AD"
and
- This report need to include all Macintosh -> Iplocation contain "Office" or Assettype : contain "Apple Mac"
I dont know how I can do this kind of report because I m noob in SQL resquest
Thanks Guys for your help.
