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

  • Want to get organized in 2022? Let Dokkio put your cloud files (Drive, Dropbox, and Slack and Gmail attachments) and documents (Google Docs, Sheets, and Notion) in order. Try Dokkio (from the makers of PBworks) for free. Available on the web, Mac, and Windows.

View
 

Report: Anzahl Rechnermodelle in Standorten

Page history last edited by Stefan Weber 12 years, 9 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.