Gary_Cherlet

IDD Reporting with IDMS/SQL

Discussion created by Gary_Cherlet on Mar 21, 2013
Latest reply on Mar 27, 2013 by Gary_Cherlet
Have you ever wanted to know, for example, all the IDD Records changed in the last 30 days by a particular User or Group of Users? Maybe the same goes for Process Code?

These sorts of queries are very easily handled by SQL queries, which use SQL Views of the IDD network database - pictures of sample queries are provided below - and a link to a ZIP file that has everything you need to implement the queries is also provided. This includes a PPT presentation that explains the installation procedure and shows you the sorts of results that you should expect to see. [color=#0810f6]Please let me know if you have any problems with trying to use this little "package"![color] To access the ZIP file of SQL Views for IDD Reporting with SQL - just click here to download-->IDD Reporting with SQL Zip file<--

Happy SQL'ing - cheers - GaryC

Outcomes