Meta-Query, bundled with Meta-Update, allows you to run any SQL query without any SQL clients. In addition, one of the script library samples, AR Tables Report <http://www.softwaretoolhouse.com/product/SthMupd/scriptlib/scr_Rpt-arschema.html> , generates a CSV of pertinent fields from arschema and adds a record count for some table types.
The distribution can be unzipped on any client machine. Deleting the files is the uninstall procedure. Trials are free and include all bundled utilities: Meta-Update, Query, Schema, Delete. Cheers Ben Chernys Senior Software Architect Description: logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: <mailto:ben.cher...@softwaretoolhouse.com> Ben.Chernys_AT_softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor and out Freebies Section for an ITSM 7.6.04 Forms and 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. <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: August-28-12 23:03 To: arslist@ARSLIST.ORG Subject: Re: driver.exe, row counts... Hi, The driver-program should work fine with the ARGetListEntry()-api-call. The important thing here is to minimize the impact on the target if you have millions of records. That is why I specify one Query List Field where I only return one byte. Secondly I specify 1 as max entries returned. You can still see the total count in "Number of matches: 174" If your server does not allow unqualified searches, you might have to add (1=1), or ('1' > 0) or something like that. Command: gle GETLIST ENTRY Schema: testform Qualifier Struct: None, And, Or, Not, Relop or From Field (0, 1, 2, 3, 4, 5) (0): Number of query list fields (0): 1 Entry list field entry Field id (0): 1 Column width (20): 1 Separator ( ): Number of sort fields (0): First Retrieve (0): Maximum number of entries to retrieve (500): 1 Get number of matches? (F): T Use Locale for search? (F): ARGetListEntry results ReturnCode: WARNING Entry List List : 1 items Entry List Struct: Entry Id : F00001 Short Description : F Number of matches: 174 Status List : 1 items Status Struct : Message type : WARNING Message number : 66 Message: The query matched more than the maximum number of entries specified for retrieval Command: Best Regards - Misi, RRR AB, <http://www.rrr.se> http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at <http://rrr.se> http://rrr.se. > You should be able to use the Misc List SQL and put in SELECT COUNT(*) > From T1920 > > That will return 1 integer value > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick > Sent: Tuesday, August 28, 2012 5:53 PM > To: arslist@ARSLIST.ORG > Subject: Re: driver.exe, row counts... > > Thanks for the quick response. > > I don't have access to the db, and can't introduce new code without > going through the change process. I was using driver.exe on another > task, and tried select count (*) from 1920, but that didn't work. > Using t1920, t1920;, 1920, didn't work either, so I thought I'd ask. > I just need a fairly quick way to keep tabs on row counts. > > rp > > -----Original Message----- > On 8/28/2012 3:00 PM, Pat Zandi wrote: >> QQ: do you need this data outside of remedy cause you can just run a >> SQL line count and put in a file on server? Vice calling from outside >> for the data? Just wondering >> >> Sent from my iPhone >> > -----Original Message----- >> On Aug 28, 2012, at 17:53, Rick wrote: >> >>> Hi, everyone, >>> >>> Is it possible to use driver.exe to determine row counts for a form? >>> I'm on 7.6.04 sp3, windows, ms sql. >>> >>> Thanks, >>> >>> Rick > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at > <http://www.arslist.org> www.arslist.org > attend wwrug12 <http://www.wwrug12.com> www.wwrug12.com ARSList: "Where the > Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at <http://www.arslist.org> www.arslist.org attend wwrug12 <http://www.wwrug12.com> www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<image003.jpg>>
smime.p7s
Description: S/MIME cryptographic signature