QA Report

[Dan Munns]

Hi all, 

After a recent audit, our QA process has been picked up as 'requires work'. 

To that end I was thinking of a scheduled task which uses a report to present me with a list of say 30 random tickets logged in the last 30 days, to run on the 1st of the month. 

Is this possible with the reporting system at the moment? And if so is there a SQL wizard (@Victor I am looking in your direction) who can lend a hand? 

Thanks 

Dan

[Victor]

7 minutes ago, Dan Munns said:

I am looking in your direction

[Victor]

Can't be done in a report I'm afraid... only via SQL...

SELECT 
    <the_fields_you_need>
FROM
    h_itsm_requests
WHERE 
    h_datelogged > (NOW() - INTERVAL 30 DAY)
ORDER BY RAND()
LIMIT 30;

 

[Dan Munns]

@Victor, yeah I have the SQL down to be fair (I think (I decided to try and smash a few of our widgets SQL together and see what happened)):

select * from h_itsm_requests where (h_datelogged >= LAST_DAY(NOW() - INTERVAL 2 MONTH) + INTERVAL 1 DAY) AND (h_datelogged < LAST_DAY(NOW() - INTERVAL 1 MONTH)) ORDER BY RAND() LIMIT 30

I was hoping for a way to present the data in a way I can just click into each ticket, have a quick look over it to make sure nothing is awry and then click into the next one. 

It is looking like at the moment I will have to create a scheduled task with the SQL query saved into the description and manually run it every month. 

Going to be a bit more work searching through all the reference numbers. 

 

Any time saving ideas? 

[Victor]

I don't think this helps but it's Friday... how about creating a view, in request list, then click randomly?

[Dan Munns]

Yeah, not really an option (although my first thought) I need it to be recorded and the requests need to be truly random so people cant accuse people of cherry picking.

Since you are skiving on holiday soon, any chance of passing this to someone? 

Also as a random thought popping into my head, could I utilise the APIs in anyway?

[Victor]

3 minutes ago, Dan Munns said:

could I utilise the APIs in anyway

There is a thought  ... Of course, you can build a tool to run or mimic the query we need... or we can explore PowerBI...

Is not really a holiday per se (I remember you said I am not really allowed any ), just some day off here and there to get some rest...

[Dan Munns]

On 10/5/2018 at 4:04 PM, Victor said:

Of course, you can build a tool to run or mimic the query we need

Ooo, how so? 

And i never said you weren't allowed holiday. Just that you had to run it past me first