!CognosComparer.accdb

From CCMDB Wiki
Revision as of 15:58, 2021 May 12 by Ttenbergen (talk | contribs) (Created page with "{{PAGENAME}} is a tool to import a range of Cognos dumps for comparison. It gets huge and is slow, so we can't just keep a running tally in there, but this allows analysis of...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

!CognosComparer.accdb is a tool to import a range of Cognos dumps for comparison. It gets huge and is slow, so we can't just keep a running tally in there, but this allows analysis of a portion. Even 2 weeks of data result in a ~500MB file. There is no de-duplication of the data, that would defeat the purpose of being able to compare.

File Location

  • \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB\CognosComparer

Instructions

It's a utility, so no niceties...

Find VBA function saveReportFilesFromMail(), update the dates and possibly .pst file to pull from, and run it manually.

If puts the data into table CognosReports. The table has a column that contains the date and time of the email with the dump file. Then queries can be run against it...

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=!CognosComparer.accdb&oldid=150488"