1
BEGIN
2
Declare score int;
3
Declare result int;
4
Declare Total int;
5
Select 1 as Total,1 as Result,
6
IFNULL(100-ROUND((((SUM(IF(OS like stringsplit(OSBadList,',',1) or OS like stringsplit(OSBadList,',',2) or OS like stringsplit(OSBadList,',',3),1*(OSBadWeight*.01),0)))+(SUM(IF(OS like stringsplit(OSWarningList,',',1) or stringsplit(OSWarningList,',',2) or stringsplit(OSWarningList,',',3),1*(OSWarningWeight*.01),0))))
7
/((Count(*)*(1*(OSBadWeight*.01)))+(Count(*)*(1*(OSWarningWeight*.01)))))*100),100) as OSScore
8
From Computers,ManagementScore Where Computers.ClientID=CID into @total,@result,@score;
9
return @score;
10
END