ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
How I can find in the GSS database a username that started a particular task?
Article ID: 207954
Updated On:
Products
Ghost Solution Suite
Issue/Introduction
Question:
Where in the GSS database might we find a username which started a particular task?
For example, when after we boot into WinPE and the DAgent connects to GSS (Ghost Solution Suite), someone will assign a task to that new computer.
Environment
GSS 3.3
Resolution
The following query may help to get the required information. You may also review tables used in this query and adjusted as needed:
select
comp.computer_name as [computer name],
ev.name as [job name],
u.name as [user name],
sl.schedule_time as [job schedule time],
sl.status as [job statuses]
from status_log sl
join computer comp on comp.computer_id=sl.computer_
join event_schedule es on es.schedule_id = sl.schedule_id
join event ev on ev.event_id = es.event_id
join securityuser u on u.user_id = sl.user_id
comp.computer_name as [computer name],
ev.name as [job name],
u.name as [user name],
sl.schedule_time as [job schedule time],
sl.status as [job statuses]
from status_log sl
join computer comp on comp.computer_id=sl.computer_
join event_schedule es on es.schedule_id = sl.schedule_id
join event ev on ev.event_id = es.event_id
join securityuser u on u.user_id = sl.user_id
Feedback
Yes
No
Powered by
