MICC Employee Audits - YSE

[Rich Mckevitt]

Hi,

Does anyone know if there is any way to either export all the employees I can see in MICC Employee tab or get to them via one of the MICC server folders? I want to run a compare with what I can see in the MiVB system as I think there are differences. Ideally by running this in to excel and doing a simple vlookup etc against the lists.

I am running MICC 9.3.1.0

All help as always is much appreciated.

Rich

Many thanks Richard

 

[Billz66]

probably have to do that in SQL

Something like this
SELECT [FirstName],[LastName],[Reporting][EmailAddress],[SupervisorLicenseType],[HasLicenseForMCC],[HasLicenseForVoice] FROM [CCMData].[dbo].[tblConfig_Employee]

can then select all , copy with headers and paste into excel

If I never did anything I'd never done before , I'd never do anything.....

 

[Rich Mckevitt]

Ok - Will give this a go

Cheers

Rich

Many thanks Richard