!CognosComparer.accdb

From CCMDB Wiki
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. 6 weeks of data result in a ~1500MB 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. The program can only handle about 6 weeks worth of data; further fine-tuning of column sizes might improve that.

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...

Log

  • 2022-12-06 - added ClientGUID to the table structure and decreased various field sizes from default 255 to 100 to be able to import more data.

Related articles

Related articles: