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

---