Service Requests Related items

I have created a Service Request for Password Resets. These requests are raised by their respective Reporting officer for their team members. I have queried with Manages user attribute in the request offering and made users to select their team members in portal during request.

These selected items are actually added to the Related Config items.

Now i wish to see a report for no. of service requests raised for each of this related config item users.(persons for whom actually password reset request raised)

How do i either take a report of this or through a view in which i need to select a class for target?

The purpose of getting this count is to find out whether any user is repeating his mistake of not recycling his / her password.

Or is there any better way of handling this request so that i can get the real count of it.

July 10th, 2015 3:35am

There are a few different ways you can accomplish this.

Most simply, you can--in the console--create a view using the Service Request class, filter on Password Resets (assuming it's in the title or elsewhere) and add the username field (that your Reporting officers add to the form to identify the user who needs a password reset) to the view...then you group by username.

Otherwise, you can build a report using SSAS by using your DWdatamart datasource and finding all service requests related to "password reset" and add username as a criteria to the report (you'll have to play with it to get it to show what you want).

Failing that, SSRS is good for directly querying the database, but you'll need to either have some SQL query knowledge or have somebody help you build it.

Free Windows Admin Tool Kit Click here and download it now
July 21st, 2015 4:26pm

There are a few different ways you can accomplish this.

Most simply, you can--in the console--create a view using the Service Request class, filter on Password Resets (assuming it's in the title or elsewhere) and add the username field (that your Reporting officers add to the form to identify the user who needs a password reset) to the view...then you group by username.

Otherwise, you can build a report using SSAS by using your DWdatamart datasource and finding all service requests related to "password reset" and add username as a criteria to the report (you'll have to play with it to get it to show what you want).

Failing that, SSRS is good for directly querying the database, but you'll need to either have some SQL query knowledge or have somebody help you build it.

July 21st, 2015 8:25pm

There are a few different ways you can accomplish this.

Most simply, you can--in the console--create a view using the Service Request class, filter on Password Resets (assuming it's in the title or elsewhere) and add the username field (that your Reporting officers add to the form to identify the user who needs a password reset) to the view...then you group by username.

Otherwise, you can build a report using SSAS by using your DWdatamart datasource and finding all service requests related to "password reset" and add username as a criteria to the report (you'll have to play with it to get it to show what you want).

Failing that, SSRS is good for directly querying the database, but you'll need to either have some SQL query knowledge or have somebody help you build it.

Free Windows Admin Tool Kit Click here and download it now
July 21st, 2015 8:25pm

There are a few different ways you can accomplish this.

Most simply, you can--in the console--create a view using the Service Request class, filter on Password Resets (assuming it's in the title or elsewhere) and add the username field (that your Reporting officers add to the form to identify the user who needs a password reset) to the view...then you group by username.

Otherwise, you can build a report using SSAS by using your DWdatamart datasource and finding all service requests related to "password reset" and add username as a criteria to the report (you'll have to play with it to get it to show what you want).

Failing that, SSRS is good for directly querying the database, but you'll need to either have some SQL query knowledge or have somebody help you build it.

July 21st, 2015 8:25pm

There are a few different ways you can accomplish this.

Most simply, you can--in the console--create a view using the Service Request class, filter on Password Resets (assuming it's in the title or elsewhere) and add the username field (that your Reporting officers add to the form to identify the user who needs a password reset) to the view...then you group by username.

Otherwise, you can build a report using SSAS by using your DWdatamart datasource and finding all service requests related to "password reset" and add username as a criteria to the report (you'll have to play with it to get it to show what you want).

Failing that, SSRS is good for directly querying the database, but you'll need to either have some SQL query knowledge or have somebody help you build it.

Free Windows Admin Tool Kit Click here and download it now
July 21st, 2015 8:25pm

There are a few different ways you can accomplish this.

Most simply, you can--in the console--create a view using the Service Request class, filter on Password Resets (assuming it's in the title or elsewhere) and add the username field (that your Reporting officers add to the form to identify the user who needs a password reset) to the view...then you group by username.

Otherwise, you can build a report using SSAS by using your DWdatamart datasource and finding all service requests related to "password reset" and add username as a criteria to the report (you'll have to play with it to get it to show what you want).

Failing that, SSRS is good for directly querying the database, but you'll need to either have some SQL query knowledge or have somebody help you build it.

July 21st, 2015 8:25pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics