After opening a ticket and working with a support person from MicroFocus to help in our discovery for MSSQL. The ticket specifically was open to help get the attribute Maximum Size populated for the SQL File CI. I received word from the support person who talked with a senior engineer about the case and they checked the OOTB scripts and they found that unfortunately there are no scripts for the SQL jobs that can discover this Maximum Size attribute. This was a suggestion from them to post this idea here in the Idea Exchange for a enhancement request for future releases to be able to discover this data.
Currently this is a required attribute from our MSSQL monitoring team to help them create monitoring templates that will be used for our customers for any MSSQL DBs they would like to have monitored.