Hi All, Just thought I would provide an update; I had more success with the following querySelect Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysOS.OSname, tblAssets.Username, tblAssets.IPAddress, tblAssets.Description, Max(Convert(dat...
Thanks for your reply, I tried the different date formats but still unable to query results over X amount of days. I believe the problem is the column data type, the InstalledOn is nvarchar but ideally should be datetime.
These reports are great but is anyone else finding the dates are wrong when compared to looking up qfe, for example if you run the following in powershellGet-WmiObject -Class Win32_QuickFixEngineering | Select-Object -Property Description, HotFixID, ...