1 of 1 people found this helpful
Sure. Run sbadmcl script with -command:ShowOldMachines -DaysOld:31
does your script user have view audit permission?
Yes, it's a full admin account.
If I login to the admin console using the same account, I can view audits... weird huh
I suggest that you rebuild database index cache.
Thanks for the suggestion, this isn't something I've come across before - and google gives no answers.
Where can I get instructions for doing this?
Ok, I've read the section about DBCFG.INI
Looking at our INI, it's basically empty, with the exception of "Trackchanges=Yes".
So, if I now edit this file, and add:
Then re-open sbadmin.exe, will this force it to create (or recreate) the index?
If you never had index then your issue is different. Look at permissions of account used for sbadmcl.
Index is a good thing. It speads database operations greatly. If you never had one, you can run:
to create cache. If you want to rebuild it, stop your database service, delete:
and run sbadmcl getcounts above.