CR report on CE 1

[willyd61]

Has anyone ever did a CR report based on the CE sqlserver? I know the APOS software has the ability to list all objects and list stuff like instances. I have tried to login to the sql-server but I did not spend alot of time. I have not any documents listing my options.

Once you get quite alot of re-occurring reports and other objects its hard to audit from the Admin Console for portfolio. How does everyone else do it?



-Willy D

 

[synapsevampire]

They don't...

You didn't state what you're audit is, which is important.

There's a CE log which you might leverage if you have static IP's and can link them to users if that's what you need.

Try stating specifically what you need as opposed to the term audit.

-k

 

[willyd61]

My fault I should have been more clear on my "audit".
Basically I want the ability to view a list of objects, amount of instances associated with those objects.

Users and group permissions to different folders, and things like this. No need for user access to reports, or these types of things.

I only want to see what lives on CE, how often they have run, what the permissions are, etc

 

[mdwyer]

If you'd like customized .csp pages that do almost exactly what you've asked, send an email to dsom8 at hotmail. I'll send you the 3 files I use and you can customize as needed.

- Mike

 

[willyd61]

I went ahead and sent you an email, thanks again for all your help.

 

[nbk13nw]

WillyD61,

I too have the same concerns. The APOS solution is failing due to the sheer size of the APS database. With over 100,000 report instances, 15,000+ recurring reports and 15,000+ users. I was hoping to find another solution that could give use similiar results and the ability to dynamically interact with these instances. Any help would be appreciated! TIA

 

[mdwyer]

Please see my previous message and email. I'll send you the same stuff I sent willyd.
(This site needs a better facility for file sharing!)
-mike