Control Compliance Suite

 View Only
  • 1.  Export evaluation details via API

    Posted Jun 25, 2014 11:10 AM

    Hi,

    we need to automate export of evaluation details (with checks, risk score and evidence) for the purpose of importing data into our warehouse. We did not find Reporting engine suitable for this so we turned to API but that also appears to be dead-end as we could not figure out which API can export evaluation details with data we need. Closest API we found is GetCheckEvaluationResults but could not figure how to use it.

    Does someone have experience with exporting evaluation data from CCS via API (or some other way) for the purpose of importing into another data warehouse?

     

    Thanks.



  • 2.  RE: Export evaluation details via API

    Posted Jul 25, 2014 12:58 PM

    You can go straight to the CCS DB's with a SQL query. 

    Web API's are usually slow anyway... as long as your DBA's allow the direct SQL connection, that'd be my suggestion.

    Just don't hit any of the CCS "Views" - they were -apparently- coded by people who don't know much about SQL and they are horrendously misconfigured. You'll get timeouts and whatnot.

    If you need further help, I can assist. I know the CCS table structure quite well.



  • 3.  RE: Export evaluation details via API

    Posted Aug 18, 2014 03:59 PM

    The API's are a bit difficult to use, but the powershell cmdlets are pretty straight forward.  If you decide to go with Matt's suggestion, then you should look at the CSM_Reports database and lookat the view vStandardCheckResultsWithEvidence.

    Hope this helps.