Add Date to Job Transfer Issues Modern Widget

brianab

I am moving over to the new Modern Dashboard for NCM and I was wondering if there would be a way to add a Date to the Job Transfer Issue Widget so we know when the job ran that got the error.
I tried to add a column but I didnt know where "Date" would be located. 

flackovic

Hello! 

Not sure if you still need the solution to this, but I figured I would include my solution since we recently started actively digging into Modern Dashboards in my environment and I also thought this was a great detail that was sadly missing!

The table you would need is the "Cirrus.NCM_NCMJobsView" table, which includes a field called LastDateRun that has the info you're looking for.

Here is my final query for this table:

SELECT Jobs.NCMJobName,
    ToLocal(View.LastDateRun) AS LastDateRun,
	Status.ErrorMessage,
	OrionNodes.Status, 
	OrionNodes.Caption,OrionNodes.DetailsUrl, 
 Status.TransferState,
	'/apps/ncm/job-log/' + ToString(Jobs.NCMJobID) as JobLogUrl,
 Status.RequestedConfigType
	FROM NCM.LatestTransferJobStatus as Status
	JOIN Cirrus.NCM_NCMJobs as Jobs on Status.JobId= Jobs.NCMJobID 
    JOIN Cirrus.NCM_NCMJobsView as View on Jobs.NCMJobID = View.NCMJobID
	JOIN NCM.NodeProperties as NCMNodes on NCMNodes.NodeID= Status.NodeID 
	JOIN Orion.Nodes as OrionNodes 
	on NCMNodes.CoreNodeID= OrionNodes.NodeID 
	WHERE TransferState=3
	ORDER BY Jobs.NCMJobName, OrionNodes.IP_Address

And here's how I configured the Column on the resource:

This gives you the following result:

Hopefully that helps! Let me know if there is anything else I can do to assist.