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.