I have a simple working sql script I wrote and want to fine tune it to days of week, or even between certain dates. Ive tried everything and am stumped at this point. The column I think I should be using says its ambiguous when I add it, so I think I'm missing syntax. Can anyone help please.
This works, now I just need to tune it for days, or dates.
FROM NPM_NV_WL_CLIENTS, NPM_NV_WL_CONTROLLERS
WHERE Client_Status = 'blank' AND Client_SSID = 'blank' AND Client_Name = 'blank'
GROUP BY Client_SSID, Client_Status, Controller_Name, Client_Name
Thanks in advance!
Solved! Go to Solution.
first you need to find out what columns in those 2 tables have dates in them and ensure they are in the context you are looking for, i.e. client status change @ x time.
then you want to use that/those columns in reporting.
Thanks njoylif, but I'm still confused. I have the column identified that I want to use where a date is located, but it still does not work. I'm using a column from table NPM_NV_WL_APS column LastUpdate and can not extrapolate the info from it. I get an ambiguous error on LastUpdate.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.