I found this report which is how I want it to look.Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,tblAssets.AssetID,tblAssetCustom.PurchaseDate As [Purchase Date],Year(tblAssetCustom.PurchaseDate) As [Purchase Year],Year(tblAssetCustom.Pur...
I'm using this report to show me all our windows servers and their used disk size. The sizes show from independent disks. The only way to consolidate is to export to excel and consolidate and sum the data - but I was thinking something similar could ...
I have a report that lists all tickets ever raised.When tickets are closed we have to check which company from our group of companies the issue was raised.I now need this report to show this info and whilst I can get it list the companies I am gettin...
Does anybody know how I would add to this report for it to identify if the USB drive was encrypted or not? I know there is another report for Encrypted Volumes which has this information so I'm guessing it can be done, I just don't know how.
Hi,Searching for report allow to map Virtual Servers to physical Hosts:- Virtual Server name (incl. OS Edition & Version)- Server Farm name (optional: incl.. Info about Status y/n for DRS, HA, V-Motion)- Physical Host (incl. Hypervisor manufacture) H...
Hi guys,Could anyone help me to pull a report that will list all admin accounts with their last logon for all computers? And also if you could also list their displayname, department, and description from AD.Many thanks! Appreciate it so much!
I have a list that we pulled out of azure with hostnames, and I have created a comma separated list in hopes of being able to plug this list into a query here and generate the data needed. For us we are only wanting to capture the Model/OS/OS Version...