I think you need possibly SUB Routine to handle a script like this
'$(vStoredTableName)' AS [Table Name],
QVDTABLENAME('$(vStorePath)$(vStoredTableName).QVD') AS [QVD Name], QVDNOOFFIELDS('$(vStorePath)$(vStoredTableName).QVD') AS [QVD No Of FIelds],
QVDNOOFRECORDS('$(vStorePath)$(vStoredTableName).QVD') AS [QVD No Of Records]
Hopefully this starts an idea for you.
Hello Good People,
Hoping if some one has already been working on a App like this as yet.
I tried create an app as per suggestions from Gabriel above. However, that approach has limitation in terms findings details on total load time at each run and the corresponding tasks.
I understand the OOB monitoring app Operation Monitor captures a quite bit of details at task reloads level.
Has anyone worked on similar app or have re-engineered the same?