Re: Re: dsm.sys question

2019-02-27 Thread Bronder, David M
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

Re: Query help joining 2 tables

2020-01-16 Thread Bronder, David M
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

Re: Re: Query help joining 2 tables

2020-01-17 Thread Bronder, David M
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