myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


SMSWEB report

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> SMSWEB report Page: [1]
Login
Message << Older Topic   Newer Topic >>
SMSWEB report - 8/14/2008 10:17:26 AM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline
Not too long ago I saw a posting about SMSWEB report and the Web Application look liked what you see in the attached image.

My Question to everyone, do you have the link to the original posting or source? (I did a search but no success..probably lost my touch ..LOL)

And based on that I'll have more questions, basicaly mof questions in regards to the monitors and printers info.

Thank you all.



Thumbnail Image
 
Post #: 1
RE: SMSWEB report - 8/14/2008 10:18:28 AM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline
here's the image


Thumbnail Image


Attachment (1)

(in reply to gkamenjati)
Post #: 2
RE: SMSWEB report - 8/14/2008 10:19:23 AM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline
Somehow I recall Francois Racine's name related to this, but i may be wrong.

(in reply to gkamenjati)
Post #: 3
RE: SMSWEB report - 8/14/2008 11:43:57 AM   
skissinger


Posts: 2167
Score: 135
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline
That looks a little like the Confirmgr Client Troubleshooter, but not exactly the same.  But it looks like Client Troubleshooter has many of the same info you were looking for, so maybe it'll work for you?

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to gkamenjati)
Post #: 4
RE: SMSWEB report - 8/14/2008 7:13:39 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline
Sorry for my delayed response (too busy), and thank you for the link to Ramsey's post (we are using it).

In regards to the subject, and as you see from the bigger PIC I uploaded I'm looking at collecting the monitor info and the local printer info, for that obviously i need to Change the mof file; and as you Sherry, i don't know how to code this into the mof file to start collecting the info.

Any help will be appreciated.

the script has this code in it related to each:

Monitor:
<%
fp_sQry="SELECT distinct monitors_DATA.modelname00 as 'Monitor Model', monitors_DATA.SerialNumber00 as 'Monitor Serial Number' FROM System_DATA INNER JOIN monitors_DATA ON System_DATA.MachineID = monitors_DATA.MachineID where System_DATA.name0 = '::computername::'"
fp_sDefault="computername="
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="SMSWEB"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=2
fp_fCustomQuery=True
BOTID=9
fp_iRegion=BOTID
%>

 
and for the printer:
<%
fp_sQry="SELECT printer_device_DATA.name00 as 'Printer Name', printer_device_DATA.Drivername00 as 'Printer Type' FROM System_DATA INNER JOIN printer_device_DATA ON System_DATA.MachineID = printer_device_DATA.MachineID where System_DATA.name0 = '::computername::' and printer_device_DATA.name00 not like '%Office Document Image%' and printer_device_DATA.name00 not like '%IXOS-ARCHIVE%' and printer_device_DATA.name00 not like 'HP Mobile%' order by printer_device_DATA.name00 "
fp_sDefault="computername="
fp_sNoRecords="<tr><td colspan=2 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="SMSWEB"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Printer Name"
fp_sMenuValue="Printer Name"
fp_iDisplayCols=2
fp_fCustomQuery=True
BOTID=10
fp_iRegion=BOTID
%>



Thumbnail Image


Attachment (1)

(in reply to skissinger)
Post #: 5
RE: SMSWEB report - 8/14/2008 8:34:05 PM   
skissinger


Posts: 2167
Score: 135
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline
Printers:  That's mildly easy.  In your existing inboxes\clifiles.src\hinv, edit sms_def.mof, and look for 'printer device'.  You'll want to change FALSE to TRUE for the class itself, and oh... probably "Driver Name", "Name", and "DeviceID" (because it's a key field).  It looks like that's all the query is using.  I wouldn't turn on more attributes unless you've checked a client's WMI and know you want those other attributes.

Edit:  Monitors

I don't know which one they were using in that front end.

< Message edited by skissinger -- 8/14/2008 9:05:53 PM >


_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to gkamenjati)
Post #: 6
RE: SMSWEB report - 8/14/2008 9:19:22 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline
Thx Sherry I'll try your printer changes tomorrow at work, in regards for the monitor script we already use it in Ron 3.21 web console and works perfectly.

to my original quest about the source, here what I was looking for

http://www.myitforum.com/downloads/default.asp?w=3&srt=52&p=&se=SMS+Queries,++Reports+and+MOFs

I knew I wasn't dreaming..LOL

I'll keep you posted.


(in reply to skissinger)
Post #: 7
RE: SMSWEB report - 8/15/2008 11:56:37 AM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline
I understand the monitor thingy might need some work, but in regards to the Printer fields I looked at my mof and the proper classes were set to TRUE, this got me thinking (Shocking huh..LOL) that the query parameters of the SMSWEB application do not match my database
so I changed it to this (red font are the changes comapring to above posted codes for the printers section)

fp_sQry="SELECT printer_device_DATA.DeviceID0 as 'Printer Name', printer_device_DATA.DriverName0 as 'Printer Type' FROM System_DATA INNER JOIN printer_device_DATA ON System_DATA.MachineID = printer_device_DATA.MachineID where System_DATA.name0 = '::computername::' and printer_device_DATA.DeviceID0 not like '%Office Document Image%' and printer_device_DATA.DeviceID0 not like '%IXOS-ARCHIVE%' and printer_device_DATA.DeviceID0 not like 'HP Mobile%' order by printer_device_DATA.DeviceID0 "

but now I get this error:
Database Results Error
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'DeviceID0'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

 
As you know i have no experience in SQL, can tell me what i should be changing in the statement.


Thank you in advance.

(in reply to gkamenjati)
Post #: 8
RE: SMSWEB report - 8/15/2008 12:53:31 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline
I solve the Printer code using this article Thank you.
http://www.myitforum.com/articles/1/print_view.asp?id=2898

My final Printer code is (notice the double 00) which i don't understand why...I'm sure someone will tel me..but it is working.

fp_sQry="SELECT printer_device_DATA.DeviceID00 as 'Printer Name', printer_device_DATA.DriverName00 as 'Printer Type' FROM System_DATA INNER JOIN printer_device_DATA ON System_DATA.MachineID = printer_device_DATA.MachineID where System_DATA.Name0 = '::computername::' and printer_device_DATA.DeviceID00 not like '%Office Document Image%' and printer_device_DATA.DeviceID00 not like '%IXOS-ARCHIVE%' and printer_device_DATA.DeviceID00 not like 'HP Mobile%' order by printer_device_DATA.DeviceID00 "

What is left is the printer thingy...I'll let you know..I think i have couple of Ideas (Impressed with myself..LOL).

(in reply to gkamenjati)
Post #: 9
RE: SMSWEB report - 8/15/2008 3:54:26 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline
Sorry what I meant is the Monitor are next.

(in reply to gkamenjati)
Post #: 10
RE: SMSWEB report - 8/15/2008 3:57:22 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline
Here's how the Printer Section looks like. Cool.



Thumbnail Image


Attachment (1)

(in reply to gkamenjati)
Post #: 11
RE: SMSWEB report - 8/15/2008 5:17:16 PM   
jnelson993


Posts: 925
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline
You're querying the printer_device_DATA table directly instead of using the view.  This is generally a bad idea.  I don't have printer information like this turned on in my MOF so I don't have a corresponding view, but it should be something like v_GS_Printer...something.  I would query that instead.  You should be able to see it when you scroll through the list of views in SQL Management Studio or SQL Query Analyzer.


_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to gkamenjati)
Post #: 12
RE: SMSWEB report - 8/18/2008 4:18:24 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline
Thx for the Tip john, I didn't know any better because I'm not a DB guy..

I've uploaded the Printer device Views to help you refrencing the codes.

So you are recommending changing the code to: (Blue Font)

fp_sQry="SELECT v_GS_PRINTER_DEVICE.DeviceID00 as 'Printer Name', v_GS_PRINTER_DEVICE.DriverName00 as 'Printer Type', v_GS_PRINTER_DEVICE.PortName00 AS 'Port Name' FROM v_R_System INNER JOIN v_GS_PRINTER_DEVICE ON v_R_System.MachineID = v_GS_PRINTER_DEVICE.MachineID where v_R_System.Name0 = '::computername::'  order by v_GS_PRINTER_DEVICE.DeviceID00 "

here's the working original:
fp_sQry="SELECT printer_device_DATA.DeviceID00 as 'Printer Name', printer_device_DATA.DriverName00 as 'Printer Type', Printer_Device_DATA.PortName00 AS 'Port Name' FROM System_DATA INNER JOIN printer_device_DATA ON System_DATA.MachineID = printer_device_DATA.MachineID where System_DATA.Name0 = '::computername::'  order by printer_device_DATA.DeviceID00 "







Thumbnail Image


Attachment (1)

(in reply to jnelson993)
Post #: 13
RE: SMSWEB report - 8/19/2008 2:34:02 AM   
jnelson993


Posts: 925
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline
Something like that...instead of MachineID, it will be ResourceID, and instead of 2 00's at the end, it would be 1 (DeviceID0), and I'd use Netbios_name0 instead of Name0 because netbios_name0 is indexed.

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to gkamenjati)
Post #: 14
RE: SMSWEB report - 8/19/2008 10:51:51 AM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline
John, your changes worked perfectly and below are the Query changes for each.

Thank you for all your help, & you too Sherry, you are the "Michael Phelps" of my SMS life. LOL.

for the printer
fp_sQry="SELECT v_GS_PRINTER_DEVICE.DeviceID0 as 'Printer Name', v_GS_PRINTER_DEVICE.DriverName0 as 'Printer Type', v_GS_PRINTER_DEVICE.PortName0 AS 'Port Name' FROM v_R_System INNER JOIN v_GS_PRINTER_DEVICE ON v_R_System.ResourceID = v_GS_PRINTER_DEVICE.ResourceID where v_R_System.Netbios_Name0 = '::computername::'  order by v_GS_PRINTER_DEVICE.DeviceID0 "


for the monior
fp_sQry="SELECT distinct v_GS_Desktop_Monitor.MonitorManufacturer0 as 'Monitor Model', v_GS_Desktop_Monitor.DeviceID0 as 'Monitor Serial Number' FROM v_R_System INNER JOIN v_GS_Desktop_Monitor ON v_R_System.ResourceID = v_GS_Desktop_Monitor.ResourceID where v_R_System.Netbios_Name0 = '::computername::'"

here's how the final product looks like.





Thumbnail Image


Attachment (1)

(in reply to jnelson993)
Post #: 15
RE: SMSWEB report - 8/21/2008 5:03:45 PM   
gkamenjati


Posts: 108
Score: 0
Joined: 6/8/2005
From: San Jose, California
Status: offline
Couple of more followup questions:

Is there a way to report on the Mapped network Printers (including queue names) and Mapped Drives (including path)?

Mil gratzi.

(in reply to gkamenjati)
Post #: 16
RE: SMSWEB report - 8/21/2008 5:25:45 PM   
skissinger


Posts: 2167
Score: 135
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline
Yes, the dataldr scripts from sccmexpert.com.  The script runs as a recurring ad only when a user is logged on to populate WMI, and a mof edit pulls the data in from WMI.

Under custom inventory, script created classes in the wiki.

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to gkamenjati)
Post #: 17
Page:   [1]
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> SMSWEB report Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.266