// ********************************************************************************* // // Created by SMS Export object wizard // // Tuesday, July 26, 2011 created // // File Name: warrcomapspec.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 a specific computer"; NumPrompts = 1; RefreshInterval = 0; ReportGUID = "{0543D000-0E0C-4231-B8AE-E946E89D3F81}"; ReportParams = { instance of SMS_ReportParameter { AllowEmpty = FALSE; DefaultValue = ""; PromptText = "Computer Name"; SampleValueSQL = "begin \n if (@__filterwildcard = '') \n SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS ORDER By SYS.Netbios_Name0 \n else \n SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS \n WHERE SYS.Netbios_Name0 like @__filterwildcard \n ORDER By SYS.Netbios_Name0 \nend"; VariableName = "Variable"; }}; 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 \nWHERE \n vrsys.Netbios_Name0 LIKE @Variable"; StatusMessageDetailSource = FALSE; UnicodeData = FALSE; XColLabel = ""; YColLabel = ""; }; // ***** End *****