Laptop HW report

Laptop HW report

Hi

We created the below report. Its good but I cant get the Hard disks sizes... How can I add this to the Query?

SELECT workstation.WORKSTATIONNAME "Workstation",workstation.MODEL "Model",workstation.SERVICETAG "Service Tag",product.COMPONENTNAME "Product",osInfo.OSNAME "OS Name" FROM SystemInfo workstation LEFT JOIN Resources resource ON workstation.WORKSTATIONID=resource.RESOURCEID inner join componentdefinitionlaptop cdl on resource.componentid=cdl.componentid LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID LEFT JOIN OsInfo osInfo ON workstation.WORKSTATIONID=osInfo.WORKSTATIONID



Thanks,
Amichy E.
                New to ADManager Plus?

                  New to ADSelfService Plus?