How do I create a report to display the Department, Company, and Employee ID fields of a user accoun (NETIQKB13171)

  • Document ID:7713171
  • Creation Date:02-Feb-2007
  • Modified Date:19-Jun-2007
    • Micro Focus Products:
      Directory and Resource Administrator

Resolution

goal
How do I create a report to display the Department, Company, and Employee ID fields of a user account?

fact
Directory and Resource Administrator 6.x

fact
Directory and Resource Administrator 7.x

fix

In order to display the user accounts properties such as:  Company, Department and Employee ID , a custom report must be created in Directory and Resource Administrator Reporting Tool.  The following are steps that should be performed in order to generate such Custom Reports:

 

  1.  Launch the 'Directory and Resource Reporting' interface.
  2. Select Enter Design Mode from the File drop down menu.
  3. Select Tables from the 'Objects' list.
  4. Select UserFields and click Open.
  5. Select Import and AlwaysImport checkboxes for the'Department' ,'Company' and'EmployeeID' fields.
  6. Select Save from the File drop down menu.
  7. Select Exit from the File drop down menu.
  8.  Launch the 'Directory and Resource Reporting' interface and perform an import, ensuring that User account details is selected.
  9. When the import is complete, close the import screen
  10. Select Enter Design Mode from the File drop down menu.
  11. Select Queries from the 'Objects' list.
  12. Select Create query in Design view and click O.
    pen    .
  13. Select USERS from the list under the Tables tab in the Show Table dialog box.
  14. Click Add | Close.
  15. Double click Company, Department, and EmployeeID from the list in the 'USERS' window.
  16. Select Save As from the'File' drop down menu, name the query Department and Company info, and click OK.
  17. Select Close from the 'File' menu.
  18. Select Reports from the 'Objects' list.
  19. Select Create report by using wizard and click Design.
  20. Select Query: Department and Company info from the 'Tables/Queries' drop down list.
  21. Click the right arrow (>)button to move the 'Company', 'Department', and 'EmployeeID' fields to the Selected Fields: box and click Next.
  22. Continue with the wizard, customizing the report format as needed.  Notice that you can set the  grouping levels for ease of viewing, sorting Company, department, or EmployeeID.   When the formatting of the report is complete, click Finish to view the report.
  23. Select Save from the File drop down menu.
  24. Select Exit from the File drop down menu.
.


note
Creation and Supporting Custom Reports is beyond the scope of NetIQ Technical Support.  The above steps are provided as an example and is not supported.

Additional Information

Formerly known as NETIQKB13171