{"id":912,"date":"2010-08-16T14:49:58","date_gmt":"2010-08-16T14:49:58","guid":{"rendered":"https:\/\/www.wapshere.com\/missmiis\/?p=912"},"modified":"2010-09-28T07:22:13","modified_gmt":"2010-09-28T07:22:13","slug":"archiving-the-import-and-export-logs-and-viewing-them-with-a-stylesheet","status":"publish","type":"post","link":"https:\/\/www.wapshere.com\/missmiis\/archiving-the-import-and-export-logs-and-viewing-them-with-a-stylesheet","title":{"rendered":"Archiving the Import and Export Logs, and viewing them with a stylesheet"},"content":{"rendered":"

A long time ago<\/a> I wrote up a method that could be used to archive the MIIS import and export logs, while also making them more readable with a stylesheet. I’ve now implemented this on a FIM 2010 server, and it works, so I’m going to write it up again.<\/p>\n

The Problem<\/h3>\n

The FIM Sync Service, just like its predecessors, only stores information about the current state of objects. Run History is almost completely worthless and should be cleared regularly<\/a>. However there will be times when you will be asked to trace through a series of events – perhaps leading to the CEO’s account being inadvertently disabled. At times like this it is important to be able to show that FIM was just responding appropriately to an imported data change, and not acting maliciously in some skynet-esque awakening.<\/p>\n

However, as we know, the import and export run profiles, while allowing a log file to be dumped, then helpfully overwrite it at the next run. We need a way to hang on to that historical data.<\/p>\n

The Proposal<\/h3>\n

If you’re already running your tasks using vbscripts it’s pretty simple to add an extra step which copies the log file off to a datestamped version in an archive location (script below).<\/p>\n

At the same time, we can do a little manipulation to the log file to make it more readable. By inserting a couple of lines in the top of the log file it can now be used with an XML Stylesheet, allowing it to be browsed in a nice table format.<\/p>\n

Provisos<\/h3>\n

The log file will only be archived if you run your export and import jobs via your scripts. Anything\u00c2\u00a0run directly from the Sync Service GUI may still produce a log file, but it won’t be archived.<\/p>\n

Also, the timestamp is a approximate as it represents the time the log was archived, rather than the exact time specific objects were modified in a target directory. But if you archive the log straight after the Export profile runs then it should be close enough for most purposes.<\/p>\n

log.xsl<\/h3>\n

First, you need to create a folder somewhere with the same sub-folders as your MaData folder (in the script example below, I’m using D:\\FIM\\MALogArchives). Then, into this new folder, create a text file called “log.xsl” and paste in this content<\/a>.<\/p>\n

ArchiveLog.vbs<\/h3>\n

Now here’s a vbscript that will copy the named log file, while modifying it to work with the stylesheet.<\/p>\n

<\/p>\n

' This script copies the export and import logs to datestamped versions\r\n' and modifies them to work with a stylesheet called ..\/log.xsl.\r\n'\r\n'   Usage: cscript archivelog.vbs MaName LogFileName\r\n'\r\n'   Eg:    cscript archivelog.vbs HR import.xml\r\n'\r\n' Written by Carol Wapshere\r\n\r\nOption Explicit\r\nConst XML_STYLESHEET = \"..\\log.xsl\"\r\nConst MIIS_FOLDER = \"C:\\Program Files\\Microsoft Forefront Identity Manager\\2010\\Synchronization Service\"\r\nConst ARCHIVE_FOLDER = \"D:\\FIM\\MALogArchives\"\r\nConst ForReading = 1\r\nConst ForWriting = 2\r\nConst ForAppending = 8\r\nConst Unicode = -1\r\n\r\nDim objFS, MaName, LogName\r\nSet objFS = CreateObject(\"Scripting.FileSystemObject\")\r\n\r\nIf WScript.Arguments.Count <> 2 Then\r\n  Usage\r\nEnd If\r\n\r\nMaName = WScript.Arguments.Item(0)\r\nLogName = WScript.Arguments.Item(1)\r\n\r\nArchiveLog MaName, LogName\r\n\r\nSub ArchiveLog(MA, LogFile)\r\n\r\n  Dim objLogFile, objArchiveFile\r\n  Dim strLogName, strArchiveName, logTime, dateStamp, strLine\r\n\r\n  strLogName = MIIS_FOLDER & \"\\MaData\\\" & MA & \"\\\" & LogFile\r\n  If objFS.FileExists(strLogName) Then\r\n    logTime = Now()\r\n    dateStamp = DatePart(\"yyyy\", logTime) & TwoChars(\"m\", logTime) &_\r\n                                 TwoChars(\"d\", logTime) & TwoChars(\"h\", logTime) &_\r\n                                 TwoChars(\"n\", logTime) & TwoChars(\"s\", logTime)\r\n    strArchiveName = ARCHIVE_FOLDER & \"\\\" & MA & \"\\\" & Split(LogFile,\".\")(0) & \"_\" & dateStamp & \".xml\"\r\n    set objLogFile = objFS.OpenTextFile(strLogName, ForReading, false, Unicode)\r\n    set objArchiveFile = objFS.OpenTextFile(strArchiveName, ForWriting, true, Unicode)\r\n    objLogFile.ReadLine()\r\n    objArchiveFile.WriteLine(\"<?xml version=\"\"1.0\"\" encoding=\"\"UTF-16\"\"?>\")\r\n    objArchiveFile.WriteLine(\"<?xml-stylesheet type=\"\"text\/xsl\"\" href=\"\"\" & XML_STYLESHEET & \"\"\"?>\")\r\n    objArchiveFile.WriteLine(\"<top>\")\r\n    objArchiveFile.WriteLine(\"<xmlfile-time>\")\r\n    objArchiveFile.WriteLine(logTime)\r\n    objArchiveFile.WriteLine(\"<\/xmlfile-time>\")\r\n    objLogFile.ReadLine() 'skip mmsml\r\n    objLogFile.ReadLine() 'skip directory-entries\r\n    strLine = objLogFile.ReadLine()\r\n    Do Until InStr(strLine, \"<\/directory-entries>\") > 0\r\n       objArchiveFile.WriteLine(strLine)\r\n       strLine = objLogFile.ReadLine()\r\n    Loop\r\n    objArchiveFile.WriteLine(\"<\/top>\")\r\n    objLogFile.Close()\r\n    objArchiveFile.Close()\r\n  End If\r\nEnd Sub\r\n\r\nFunction TwoChars(dtvar, time)\r\n  Dim i\r\n  i = DatePart(dtvar, time)\r\n  If i < 10 Then\r\n   TwoChars = \"0\" & CStr(i)\r\n  Else\r\n   TwoChars = CStr(i)\r\n  End If\r\nEnd Function\r\n\r\nSub Usage\r\n  Wscript.echo \"Usage: cscript archivelog.vbs MaName import|export\"\r\n  Wscript.Quit\r\nEnd Sub<\/pre>\n
\u00c2\u00a0<\/p>\n
<\/code><\/p>\n
Modify the Run scripts<\/h3>\n
Your last step is to modify your scheduled scripts to archive the import\/export log directly after the task has run.<\/p>\n
<\/p>\n
cscript AD_Export.vbs\r\ncscript ArchiveLog.vbs \"AD MA\" export.xml<\/pre>\n
\u00c2\u00a0<\/p>\n
<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"
A long time ago I wrote up a method that could be used to archive the MIIS import and export logs, while also making them more readable with a stylesheet. I’ve now implemented this on a FIM 2010 server, and it works, so I’m going to write it up again.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":[]},"categories":[42,9,10],"tags":[],"class_list":["post-912","post","type-post","status-publish","format-standard","hentry","category-fim-2010","category-logs","category-vbscript"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pkp1o-eI","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts\/912","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/comments?post=912"}],"version-history":[{"count":11,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts\/912\/revisions"}],"predecessor-version":[{"id":1778,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts\/912\/revisions\/1778"}],"wp:attachment":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/media?parent=912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/categories?post=912"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/tags?post=912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}