Daniel is there a report I can pull all the Hardware information from the last 90 days.I was using this sql Query.declare @LastSeenDays intset @LastSeenDays = 90select upper(a.Domain) as DomainName, upper(a.AssetName) as DeviceName, --replace(repl...

Hi All,I am still learning SQL and was wondering if there is a way to create a query to be able to pull a report to list all software installed on each asset. I originally had this query but it does not list the OS. Select tblAssets.AssetName,tblAsse...

Hi,I am not a SQL guru so I need help. My customer has Lansweeper 5.1.0.50. I need to create one query for a hardware file that produces DomainName,DeviceName,OperatingSystem,DeviceType,ServicePack,IPAddress,PhysicalOrVirtual,Computer Make, Model Ser...