AnsweredAssumed Answered

Amateur SQL query builder for reports

Question asked by kiran.bangera Advocate on Mar 8, 2018
Latest reply on Apr 11, 2018 by Viktors

I am trying to run some SQL reports and am totally new on SQL queries i have some internal team who are ready to help me but challenges that they face is snow database tables name. While building queries it is very difficult for them to get proper table names eg tblApplication, tblManufacturer tca.ApplicationID. I had some queries that mark.potts had developed previously and shared which are quite helpful like End of Support, Windows 10 build. We can pull reports in SLM but sometimes we require some custom reports which cannot be generated in SLM so SQL queries are more helpful. Can anyone help me on how to look into proper tables for building my reports. 

Outcomes