User identity mapping system and method of use

1. An identity mapping system, comprising:

an identity mapping database;

an access log including first user data related to user access of a first software application and second user data related to user access of a second software application, wherein the first software application is different from the second software application, and the first software application and the second software application are individually associated with respective users; and

a master user table (MUT) communicatively coupled with the identity mapping database and the access log, wherein the MUT includes a first record having a first record data field, a unique user identification (ID) field and a first user data field, the first user data field containing the first user data from the first software application, and a second record having a second record data field different than the first record data field, the unique user identification (ID) field and a second user data field different than the first user data field, the second user data field containing the second user data from the second software application.

2. The identity mapping system of claim 1 , wherein the MUT is exported from one of a database table, a directory service or a spreadsheet and wherein the user data includes identification of the first software application, the second software application, a record accessed, a number of records accessed, a start time of access, an end time of access, a location of access, or a user identification (UID).

3. The identity mapping system of claim 1 , wherein the at least one record data field includes a unique record number associated with each record.

4. The identity mapping system of claim 3 , wherein the unique record number associated with each record is a row number in the MUT.

5. The identity mapping system of claim 1 , wherein the at least one record data field includes a master record start time field and a master record end time field.

6. The identity mapping system of claim 1 , wherein the at least one user data field containing data from a software application includes a user hire date field and a user termination date field.

7. The identity mapping system of claim 1 , wherein the at least one record data field includes a master record start time field and a master record end time field.

8. The identity mapping system of claim 1 , wherein the at least one user data field containing data from a software application includes a user hire date field and a user termination date field.

9. The identity mapping system of claim 1 , wherein the first software application and the second software application have different perceived reliabilities.

10. An identity mapping system, comprising:

an access log including first user data related to user access of a software application, the access log including a first user identification (UID) associated with a first software application and a second user identification (UID) associated with a second software application different than the first software application, wherein the first software application and the second software application are individually associated with respective users;

at least one human resources (HR) directory having second user data selected from a primary active HR directory, additional active HR directories or other HR directories;

an identity mapping database; and

a master user table (MUT) communicatively coupled with the identity mapping database, wherein the MUT includes a record having at least one record data field, a unique user identification (ID) field and at least one user data field, the at least one user data field comprising the first user data or the second user data selected by a highest priority assigned to one of the access log and the at least one human resources (HR) directory.

11. The identity mapping system of claim 10 , wherein the at least one user data field is populated with user data from the at least one HR directory having a higher priority than user data from the software application.

12. The identity mapping system of claim 10 , wherein the at least one user data field is populated with user data from the at least one HR directory having a higher priority than user data from an at least one access log.

13. The identity mapping system of claim 10 , wherein the at least one user data field is populated with user data from the at least one access log having a higher priority than user data from the at least one at least one HR directory.

14. The identity mapping system of claim 10 , wherein the first software application and the second software application have different perceived reliabilities.

15. A method of automatically generating a report with an identity mapping system, comprising:

reviewing one or more master user table (MUT) records with an identity mapping database to identify first records corresponding to a request for a report by comparing a first field in the MUT records;

identifying second records from the first records by comparing a second field in the first records; and

recording at least a portion of each of the second records in the report,

wherein the MUT includes a first user data field and a second user data field each having user data from an access log, the access log including the user data related to user access of a first software application and a second software application different than the first software application, and the first software application and the second software application are individually associated with respective users.

16. The method of claim 15 wherein the requested report is a hidden users report that identifies users having a username for at least one software application and not having a unique user identification (ID).

17. The method of claim 15 wherein the requested report is a dormant users report that identifies users having a username for at least one software application that have not had recent interaction with that software application as defined by a predetermined time or time period.

18. The method of claim 15 wherein the requested report is an application access report that identifies a most recent access date for each software application associated with a user.

19. The method of claim 15 wherein the requested report is an access right audit report that identifies software application access inconsistent with at least one organizational rule.

20. The method of claim 15 wherein the requested report is a departed user access report that identifies software application access after a user's termination date.

21. The method of claim 15 wherein the requested report is a shared logins report that designates records as being shared among a plurality of users if at least one organizational rule indicates some fields are associated with a shared login.

22. The method of claim 15 wherein the requested report is a role definition report that groups users having similar highest to lowest frequency of software application use.

23. The method of claim 15 , wherein the first software application and the second software application have different perceived reliabilities.

24. A method of identifying a user of a software application, comprising:

applying a rule for comparing at least one user field from the software application against a corresponding field in a record in a master user table (MUT), wherein the at least one user field is not associated with a known user of the software application; and

identifying a match by comparing the at least one field from the software application against the corresponding field in the record in the master user table (MUT), wherein a portion of the at least one user field from the software application is identical to a portion of the corresponding field in the record in the master user table (MUT), and the record in the master user table (MUT) is associated with a known individual,

wherein the MUT includes at least one user data field having user data from an access log, the access log including user data related to user access of the software application and another software application different than the software application, the software application and the another software application are individually associated with respective users.

25. The method of claim 24 , wherein the rule is a matching rule selected from a plurality of matching rules based on a priority that reflects a reliability of the at least one user field.

26. The method of claim 24 , wherein the rule is a suggested matching rule selected from a plurality of suggested matching rules.

27. The method of claim 24 , wherein the rule is a matching rule that identifies more than one field from the software application and one field in the record in the master user table (MUT).

28. The method of claim 27 , wherein the one field from the software application and one field in the record in the master user table (MUT) includes a social security number (SSN).

29. The method of claim 24 , wherein the rule is a suggested matching rule that identifies more than one field from the software application and one field in the record in the master user table (MUT).

30. The method of claim 29 wherein the one field from the software application and one field in the record in the master user table (MUT) includes a social security number (SSN).

31. The method of claim 24 , further comprising:

applying a secondary rule for comparing a secondary user field from the software application against a corresponding secondary field in a record in a master user table (MUT), wherein the secondary field is not associated with a known user of the software application.

32. The method of claim 31 , wherein the secondary rule is a matching rule selected from a plurality of matching rules.

33. The method of claim 31 , wherein the secondary rule is a suggested matching rule selected from a plurality of suggested matching rules.

34. The method of claim 24 , wherein the software application and the another software application have different perceived reliabilities.