Re: Count number of folder in sms 2003 sp2 report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Go Garth!
--
Standarize. Simplify. Automate.


"Garth" wrote:

Try this... http://smsug.ca/blogs/garth_jones/archive/2007/12/28/842.aspx

"Kim Oppalfens [MVP]" <""Kim dot Oppalfens\"@google mail.com"> wrote in
message news:%23w7e5PGSIHA.4272@xxxxxxxxxxxxxxxxxxxxxxx

Go Garth, Go Garth, (picture me and Sherry doing the silly dance where we
move our arms in front of us in a counter clockwise order, that should get
you motivated). Good luck on the exam.

Garth wrote:
I'm on holidays this week and I'm doing a deep dive into the 70-622 exam
J with any luck I will be ready to pass the exam next week.



However I only have 2 more preposted blog, so after the World junior’s
hockey game tomorrow I will give this top priority. J




"Sherry Kissinger [MVP-SMS]" <mofmaster@xxxxxxxxxxxxx> wrote in message
news:99DF3B0B-C218-4782-9C05-91EA39BC8A7C@xxxxxxxxxxxxxxxx
Sounds like a challange smackdown! Excellent! Garth?!
--
Standarize. Simplify. Automate.


"Kim Oppalfens [MVP]" <""Kim dot Oppalfen" wrote:

Sherry Kissinger [MVP-SMS] wrote:
Do you mean reported from a machine from software inventory?

select count(sf.FilePath) [Count] from v_gs_softwarefile sf join >
v_r_system
sys on sys.resourceid=sf.resourceid where sys.name0 = @computername

Or somewhere else; like the # of folders in your package source
dirs? > (which
I can't see an easy method, either)
I am looking for the organizational folder objects in the sms 2003
console, that were added in sms 2003 sp1 if I am not mistaken, but I am
not having a lot of luck figuring this one out, might just be undoable.
(Not sure whether it really is, but it is probable going to be enough
of
a challenge for Garth to write a blog post about it :-)

--
"Everyone is an expert at something"
Kim Oppalfens - Sms Expert for lack of any other expertise
Windows Server System MVP - SMS
http://www.blogcastrepository.com/blogs/kim_oppalfenss_systems_management_ideas/default.aspx



.

Relevant Pages

  • Re: SMS_CLIENT_CONFIG_MANAGER
    ... ok, thx Garth. ... Dharam Deo ... not have rights to access the client machine. ... Confirm that the IP address within SMS Resource Explorer and the Real ...
    (microsoft.public.sms.admin)
  • Re: Reporting problem
    ... "Garth" wrote: ... have 2 SMS environments and I would like to get all the queries to ... "Bryan" wrote: ... Some are fine and these are all the standard reports. ...
    (microsoft.public.sms.admin)
  • Re: Count number of folder in sms 2003 sp2 report
    ... Let it be known, Garth is THE man. ... Windows Server System MVP - SMS ... Good luck on the exam. ...
    (microsoft.public.sms.inventory)
  • Re: Count number of folder in sms 2003 sp2 report
    ... Let it be know, Garth is THE man. ... Windows Server System MVP - SMS ... Good luck on the exam. ...
    (microsoft.public.sms.inventory)
  • Re: Reporting problem
    ... "Garth" wrote: ... Does MS have a fix that I can apply to fix the rest of the queries? ... have 2 SMS environments and I would like to get all the queries to work. ... Some are fine and these are all the standard reports. ...
    (microsoft.public.sms.admin)