Highlighted
Super Contributor.. Super Contributor..
Super Contributor..
400 views

SQL Query for find the timeslots who booked for what hosts

Hi,

Please provide an SQL query for finding the time slots who booked on what LG for a particular point of time. I can filter out the timeslots in Grid view but there is no option to filter with hosts. 

Need to go and see each timeslot for hosts, it is very time consuming. so please provide the SQL query for the same.

Or any better alternate approach will be welcome. Thanks in Advnce. 

Tags (1)
0 Likes
3 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: SQL Query for find the timeslots who booked for what hosts

Hi,

Please look under the report titled "timeslot usage" under Performance Center->Usage Reports section either under LAB Management or under the PC website for viewing this kind of data.

Thanks,

 

Microfocus Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Re: SQL Query for find the timeslots who booked for what hosts

Please understand the question, we are not asking how to view the data? We are asking the SQL query to view the data in backend.

As we already know in GUI, but there is no filter option to view the hosts, each and every time you need to go particular timeslot to view the hosts assigned to that timeslot.

0 Likes
Highlighted
Super Contributor.. Super Contributor..
Super Contributor..

Re: SQL Query for find the timeslots who booked for what hosts

Or in other word, Please provide the query to view in Site Admin -> Lab Management 

SQL Query to execute : To find the hosts assigned to the timeslots

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.