Trying to pull specific fields out of the database tables "LastContact" and listing the output with a timestamp (LastContact), ManagerName (hostname), OSType etc. This is the query I'm using:
SELECT [Hostname], [ManagerName],[OSType],[LastContact]FROM [SCSPDB].[dbo].[ASSET_VW] WHERE LastContact < dateadd(day,-1,getdate());
Works fine in SQL Explorer but not in DBX (errors out with the "index 1 out of range" message). Do I need to change my query from using a Rising Column (LastContact) to something else?
... View more