// ********************************************************************************* // // Created by SMS Export object wizard // // Tuesday, July 26, 2011 created // // File Name: WarrInAllComp.mof // // Comments : // // // ********************************************************************************* // ***** Class : SMS_Report ***** [SecurityVerbs(140551)] instance of SMS_Report { Category = "Custom - Hardware"; Comment = ""; GraphCaption = ""; GraphXCol = 1; GraphYCol = 2; MachineDetail = FALSE; MachineSource = FALSE; Name = "Warranty Info for all computers"; NumPrompts = 0; RefreshInterval = 0; ReportGUID = "{DD03E9A3-4C6E-4DF3-B9F3-905284A755C2}"; SecurityKey = ""; SQLQuery = "SELECT \nName0 AS Name, \nTimeStamp AS [Script Run Date], \nDescription0 AS Description, \nProvider0 AS Provider, \nStartDate0 AS [Start Date], \nEndDate0 AS [End Date], \nDATEDIFF(DAY,GETDATE(),vgswi.EndDate0) AS [Days Left], \nStatus0 AS Status \nFROM \nv_GS_Warranty_Info0 vgswi \nLEFT JOIN v_R_System AS vrsys \n ON vgswi.ResourceID = vrsys.ResourceID"; StatusMessageDetailSource = FALSE; UnicodeData = FALSE; XColLabel = ""; YColLabel = ""; }; // ***** End *****