I think that the partition query requires SQL Server Standard or higher RayHeathTSS wrote:RayHeathTSS wrote:I am getting this Error:There was an error parsing the query. [ Token line number = 1,Token line offset = 613,Token in error = With ]When I u...
I am not sure why it is not working for you, I assume you are running the database on SQL server not SQL express?Rick I wrote:Lansweeper v. 7.1.100.16Tom D wrote:What version are you running I am running Version 7 (Latest), I am unsure as to what ver...
What version are you running I am running Version 7 (Latest), I am unsure as to what version this requires. I wrote all the code in just SQL Server studio, then ported it to the WebUI. What version are you on?Rick I wrote:Tom D,Not sure what this m...
Since I use VMware here I added this so I can see all desktops + servers + VMware hosts ( am sure you can do the same for the HyperV tables.All Assets + BIOSSelect Top 1000000 tblAssets_1.AssetID, tblAssets_1.AssetName, tblAssets_1.Domain, tblAsse...
And that is exactly why the code wouldn't work for the other bit. Thanks for catching that..All Machines with their BIOSSelect Top 1000000 tblAssets_1.AssetID, tblAssets_1.AssetName, tblAssets_1.Domain, tblAssetCustom.Manufacturer, tblAssetCusto...