One of the sample scripts of Meta-Update does just that :) It’s about 3 lines, does an SQL query on arschema and picks up a select count(*) for each non-dialog join table.
Cheers Ben Chernys Senior Software Architect logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: <mailto:Ben.Chernys_AT_softwaretoolhouse.com> Ben.Chernys_AT_softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for an ITSM 7.6.04, 8.0, 8.1 Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. Pre ITSM 7.6.04? Clarify? Roll your own? No problem! You can keep your valuable data! <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kemes, Lisa A DLA CTR INFORMATION OPERATIONS Sent: June-24-14 15:20 To: [email protected] Subject: Re: ARS forms and number of records Great Idea! I voted. Thanks! Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Tuesday, June 24, 2014 9:16 AM To: [email protected] Subject: Re: ARS forms and number of records ** You may want to head over to communities and vote for this idea :) https://communities.bmc.com/ideas/3714 On Tue, Jun 24, 2014 at 3:51 AM, MalviyaSaurabh <[email protected]> wrote: Hi All, I would really like to know whether we have a tool or way of getting to know all forms (tables) and the number of records present in those forms (tables) I am aware of the backend (oracle) queries which will do, but since the number of forms are too may hence wanted to know if i it can be achieved by some tool. ARS v : 7.1.01 OS: Solaris DB: Sybase Regards, Saurabh -- View this message in context: http://ars-action-request-system.1.n7.nabble.com/ARS-forms-and-number-of-records-tp117553.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.3485 / Virus Database: 3955/7732 - Release Date: 06/23/14 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
smime.p7s
Description: S/MIME cryptographic signature
