Skip to content

{ Category Archives } VBScript

Archiving the Import and Export Logs, and viewing them with a stylesheet

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.

Repairing links in Excel documents

Another off-topic post today, because lately it’s all been migrations – Exchange migrations, data migrations, printer migrations…. I think I might have to rename this blog Miss Migrations!
As part of an enourmous data migration involving server name and drive letter changes, I was tasked with repairing links in thousands of Excel spreadsheets. We trialled a [...]

Troubleshooting missing group member errors

In some implementations, it makes sense (usually by improving performance) to separate your user and group provisioning into seperate MAs. One downside of this approach, however, is that you can run into export errors when trying to update a group with a member who doesn’t exist in the external directory – and this includes delete [...]

The ILM_Scheduler is now available for download

As promised, I am now making my ILM_Scheduler service source code available for download.
In brief, the notion is to optimise ILM/MIIS scheduling through the use of a queue. You add jobs to the queue and they are executed, one at a time, and in order of priority. You can schedule a job by adding it [...]

A few new or updated vbscript snippets

Function RunProfile - run a MA run profile
Sub ArchiveLog - copy import and export logs to a timestamped version, while modifying them to work with a XML stylesheet
Function ExportsPending - check if the MA has pending exports
Function DeltaImportsPending - check if a Delta table has any lines to import
Function RunSSIS – call a SQL 2005 SSIS Package

Archiving Exchange 2007 mailboxes

A truly effective IdM system should be able to tidy up user data as part of the user-decommissioning process. This might include zipping up home folders and, in the case of email, archiving mailboxes to something like a PST file.
My old method of archiving mailboxes with Exmerge when disabling Exchange users won’t work with Exchange [...]

Updating AD attributes from an Excel spreadsheet

You don’t always have access to a proper IdM system. At the moment I’m at an organisation which still uses the old, manual ways of updating AD. I was asked if I knew an easy way to update the mobile phone numbers of a list of users, the data having been sent to Helpdesk in [...]

A Stylesheet for the Import and Export Logs

Follwing on from yesterday’s post, where I wrote about hanging on to your import and export logs, I now present a way to view them using an xml stylesheet.
The first problem with this approach is that the xml files produced by MIIS don’t work with a stylesheet. The stylesheet name must be included in [...]

Getting the Value from your Import and Export Logs

As I’ve mentioned before, I don’t think there’s a lot of value in keeping days of Run History. Far more useful are the Import and Export logs that you should be dumping from your Run Profiles. Using these files you can track exactly what went in and out, and more importantly, when it happened. This [...]

Combining DTS with MIIS Imports

Continuing on from this post, let’s say you’ve got a DTS package that is successfully creating Delta tables. You will now want to combine this with your MIIS Delta Import job.
Simple Scheduling
If your system is not particularly time critical you may be able to get away with very basic scheduling. SQL allows you to schedule [...]