SysLastValue table is available in the AOT. Look at System Documentation >
Tables. You can right-click and browse this table.
Regards
Steve
_____
From: el8tion [mailto:[EMAIL PROTECTED]
Sent: Saturday, 4 September 2004 4:14 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] getting usage data fron SysLastValue table
I'm still pretty much a SQL novice. I was wondering if anyone might
be able to help me figure out what is probably a simple thing - hard
to say.
I'm trying to find out what forms, reports, etc have been used in an
Axapta installation, using the SysLastValue table. I notice it
doesn't show up in the AOT. I've been using the SQL Query Analyzer.
I only want rows where a combination of two fields is unique - those
fields are recordtype and elementname. There can be many records with
the same recordtype and elementname but I only want to grab one
occurance - I guess the first. For example there could be dozens of
records with recordtype '11' and elementname 'SysQueryForm' - I only
want one in the results.
Below is the query I'm using to get all the records.
select recordtype, elementname, userid, company from syslastvalue
where company = 'mm' ORDER BY recordtype, recordtype;
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129qqjtih/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705006764:HM/EXP=1094536246/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=255652405>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
<http://groups.yahoo.com/group/development-axapta/>
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor |
| Get unlimited calls to U.S./Canada |
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
