I have no idea how to write a SQL report so i'm hoping somone one can help me out. I currently am using costpoint and cognos as a report writer. Can someone tell me how i can create a sql query telling what folks have done in CP? People are saying that they are working from home but I know they aren't but can't prove it.
To know what people are doing in Cognos, you need Cognos Auditing Setup. With Auditing setup, you can run standard reports or create custom reports on the Audit Data model.
What is costpoint?
Sorry, don't know anything about Cost Point, never heard of it?