| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Report: Anzahl Rechnermodelle in Standorten

Page history last edited by Stefan Weber 14 years, 12 months ago

Zusammenfassung

 

Der Report ermittelt pro Active Directory Standort Rechnermodelle und deren Anzahl

 


 

Ausgabe

 

  • Standort
  • Hersteller
  • Modell
  • Anzahl

 


 

SQL

 

select rs.AD_Site_Name0 as 'Standort',
  hs.Manufacturer0 as 'Hersteller',
  hs.Model0 as 'Modell',
  COUNT(hs.Model0) as 'Anzahl'
from v_GS_COMPUTER_SYSTEM hs
inner join v_R_System rs on hs.ResourceID=rs.ResourceID
group by rs.AD_Site_Name0,hs.Manufacturer0, hs.Model0
order by rs.AD_Site_Name0



Comments (0)

You don't have permission to comment on this page.