Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
select Users.Department ,CONVERT(VARCHAR(11), IA.INDEX_END_DT, 106) AS Index_Date ,month(IA.INDEX_END_DT) as MonthNo ,Users.Name + ' ' + Users.[Surname] as UserName ,lastname + ' ' + firstname as Username1 ,Username ,IA.INDEX_OPERATOR ,COUNT(DISTINCT Batch_ID) AS Volume ,task = 'Indexing' from IA..ia_mysql_etl IA left join IA..Combined_Interval_User_Lookup Users on Users.[fNumber] = RIGHT(IA.INDEX_OPERATOR,8) left join QUICKSELL.orgman.[public].org_user PUser on Puser.Username = RIGHT(IA.INDEX_OPERATOR,8) where IA.INDEX_END_DT between @StartDate and @EndDate and IA.INDEX_START_DT IS NOT NULL and puser.active = '1' GROUP BY Users.Department ,CONVERT(VARCHAR(11), IA.INDEX_END_DT, 106) ,month(IA.INDEX_END_DT) ,Users.Name + ' ' + Users.[Surname] ,lastname + ' ' + firstname ,Username ,IA.INDEX_OPERATOR
|Cannot resolve the collation - tempdb..#Carriers||3||34|
|Another way of doing this SQL||8||32|
|Need help with the proper SQL syntax when querying a linked Server||1||34|
|SSIS how to COMPARE a data column from different servers?||6||48|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!