In this report how are the highlighted values being populated with text? [Description: cid:[email protected]] It's not being converted from a numeric value in the SQL:
if @ResourceID is null select top 1 @ResourceID=ResourceID from v_RA_System_ResourceNames where Resource_Names0 like (@ComputerName+N'%') select top (@TopN) t.DetectionID, t.DetectionTime, IsNULL(tc.Name,t.ThreatName) as ThreatName, cat.Category, sev.Severity, t.PendingActions, t.Process, t.UserName, t.Path, t.CleaningAction, t.ActionSuccess, t.DetectionSource from v_R_System s join v_GS_Threats t on s.ResourceID=t.ResourceID left join v_ThreatCatalog tc on t.ThreatID=tc.ThreatID left join v_ThreatSeverities sev on tc.SeverityID=sev.SeverityID left join v_ThreatCategories cat on tc.CategoryID=cat.CategoryID where s.ResourceID=@ResourceID<mailto:s.ResourceID=@ResourceID> and DATEADD(day, 0, DATEDIFF(day, 0, t.DetectionTime)) between @StartDate and @EndDate order by t.DetectionTime DESC But it's stored in a numeric value in the database: [cid:[email protected]] ________________________________ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
<<inline: image001.png>>
<<inline: image002.png>>
