For a pure TSM/SP client solution, beyond what can be done with an inclexcl
file or server-side client option sets as you and Skylar have already noted,
I think you're out of luck.
You probably have several options from the Puppet side, though...
You could use file_line resource in Pupppet's stdl
I think you can do it without the explicit join (I'm sure an actual SQL
expert could explain the difference). (I also added some formatting of the
age and occupancy output):
SELECT '$myTsmServer' AS TsmServer, FS.Node_Name, FS.Filespace_Name, -
FS.Filespace_ID, SUM(OC.Num_Files) as NUM
form Services
> Office of the Chief Information Officer
> 1305 E Walnut Street | Des Moines, IA 50319 - Mailing
> mobile 515-669-4325
> ocio.iowa.gov
>
>
> On Thu, Jan 16, 2020 at 8:11 PM Bronder, David M
> wrote:
>
>> I think you can do it without the explicit j