Robert,My wife tells me I'm not the sharpest bowling ball out there so forgive me for my ignorance.  Can you provide a little more detail so I can understand exactly what you're trying to accomplish in the end?Thx,TF

Hi Art,SQL isn't my specialty either.  Perhaps this would be an easier way to get the information? (Sorry, not free ) :

Would something like this work?Where you can even create customized reports based on the Dept field from UCM:And have them automated and emailed on a scheduled basis:

Hi James,Don't know if this would work for you but this app creates a report like this and can export to a spreadsheet:

Hi Denis,Did anyone help you with this?  I'd like to see if anyone has a script to share to remove the ITL file....Also, could I see the script you wrote to change between versions - that sounds like a timesaving feature for me....Thanks.