As we want to be able to check if SRS is working proper, we are looking for a reliable method to check some parameters in our environment to be sure, that SRS is up to date.
Currently we do this on one hand with checking if DUJ was executed successfully. But, as we found out this is no guarantee, that our SRS-Rules are really up to date.
So we got some sql statements from Snow to do a deeper analysis and also to be able to compare both of our environments:
--Shows the latest Date of an SRS application definition update
select max (SRSupdatedate) from tblapplication
--Shows the current number of Snow's global generated application definitions
select count(*) from tblApplication
where GloballyGeneratedApplication =1
--Shows the current number of application rules created by Snow
select count(*) from tblapplicationrule
where CreatedBy like 'Snow'
These statements give you transparency over the last record updated and also the number of application definitions and rules generated by Snow.
Currently (2019-10-09 17:00:06.680) we count: 626'600 applications and 781'609 application rules.
(unfortunately we have some less in our test environment 626'593 and 781'595, created a ticket to clarify why)
A second check we do is the Applications count in SMACC which shows 571'969 (571'962)
My questions are:
- Can anyone confirm that these statements are 100% reliable and showing correct results?
- Does anyone have additional checks or requirements?
- Can Snow provide somewhere a number of records (rules) a customer can compare with?