Can you display nulls in web reports?

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:

Can you display nulls in web reports?

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 >> Can you display nulls in web reports?

Page: [1]

Message

<< Older Topic Newer Topic >>

Can you display nulls in web reports? - 11/14/2008 7:51:42 AM

jmcleish

Posts: 513
Score: 17
Joined: 11/8/2002
Status: offline

How do you allow nulls in web reports?

I'm doing an inventory of machines and there is one laptop (that I know of) that doesn't get listed. Looking through resource explorer there is not a class for processor or memory.
I don't know why there isn't one and its been off for a couple of months (pool laptop) and I'll get round to getting a look at it, but for the time being I have to produce a report that lists ALL machines.

So can I get the machine listed with the info that it does have, but have nothing in the columns that don't exist? i.e for operating system CSD version- if a machine has no service pack it shows nothing in the column.

Or is that linked to the tables and whether they allow nulls values or not??

Now I'm wondering how many other machines may not be listed due to this.

Thanks

Jane

Post #: 1

RE: Can you display nulls in web reports? - 11/14/2008 1:33:04 PM 1 votes

jnelson993

Posts: 959
Score: 132
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

Well, it depends on the query and how you're joining and filtering. There's not one answer as to how to display nulls. If you're joining a bunch of views together and the nulls are getting filtered out, you need a left or right join depending on which has the nulls, if you've got a filter criteria that's filtering out nulls, you'll need to change the filter criteria to also allow nulls (there's a couple of ways to do that too).

So, like always..."it depends".

From which query/report are you trying to get NULLs?

_____________________________

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

(in reply to jmcleish)

Post #: 2

RE: Can you display nulls in web reports? - 11/17/2008 6:40:06 AM

jmcleish

Posts: 513
Score: 17
Joined: 11/8/2002
Status: offline

Hi John,

Thanks for the reply. I understand now (understand I need to spend lots of time looking at joins!)
We 're back to this report:

Select distinct SYS.Netbios_Name0, SYS.User_Name0, v_GS_computer_system.Manufacturer0,v_GS_computer_system.Model0, WK.LastHWScan,
bios.SerialNumber0 SerialNumber, v_GS_NETWORK_ADAPTER_CONFIGUR.MACAddress0, OPSYS.Caption0 as C054, OPSYS.CSDVersion0, PR.MaxClockSpeed0, MEM.TotalPhysicalMemory0
from v_R_System as SYS
join v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID=OPSYS.ResourceID
join v_GS_pc_bios as bios on SYS.ResourceID=bios.ResourceID
join v_GS_PROCESSOR PR on SYS.ResourceID=PR.ResourceID
JOIN v_GS_NETWORK_ADAPTER_CONFIGUR on v_GS_NETWORK_ADAPTER_CONFIGUR.resourceid = sys.resourceid
join v_GS_SYSTEM_ENCLOSURE SE on SYS.ResourceID=SE.ResourceID
join v_GS_X86_PC_MEMORY MEM on SYS.ResourceID=MEM.ResourceID
join v_GS_WORKSTATION_STATUS WK on SYS.ResourceID=WK.ResourceID
JOIN v_GS_computer_system on v_GS_computer_system.resourceid = sys.resourceid
join v_FullCollectionMembership FC on FC.ResourceID = SYS.ResourceID
where FC.CollectionID = 'W010021b' and (v_GS_NETWORK_ADAPTER_CONFIGUR.dhcpenabled0 = 1 and v_GS_NETWORK_ADAPTER_CONFIGUR.ipsubnet0 like '255.255%' and v_GS_NETWORK_ADAPTER_CONFIGUR.ipaddress0 like '10%')
order by SYS.Netbios_Name0

As I said above, I've found a machine that has no memory or processor field in resource explorer for whatever reason, so I'm thinking what other clients have inventory problems?

Ideally I'd like to be able to have the system name column, then get it to display nulls for all other selected columns if possible. That way I'd have a list of definites for what needs fixed, and a true representation of all machines without it missing those items that haven't reported properly.

That's probably not possible!

Thanks

Jane

EDIT:

Thanks John for your help- I changed all the joins to left outer joins and I now have 60 more machines than in my last report!

Dude - you're THE man!

Thanks again.
:-)

Is this what you're talking about the filter criteria - or is there something that I could still be missing?

Jane

< Message edited by jmcleish -- 11/17/2008 7:11:14 AM >

(in reply to jnelson993)

Post #: 3

RE: Can you display nulls in web reports? - 11/17/2008 9:49:24 AM

jmcleish

Posts: 513
Score: 17
Joined: 11/8/2002
Status: offline

OK- so that report is working sweet, however, everytime I go to link it computer details, it bombs out with

Response object error 'ASP 0251 : 80004005'
Response Buffer Limit Exceeded
/smsreporting_W01/Report.asp, line 0
Execution of the ASP page caused the Response Buffer to exceed its configured limit.

I changed the aspbuffer limit as mentioned by John in my other post http://www.myitforum.com/forums/Web_report_for_inventory_help/m_189542/tm.htm (thanks!) but to test it, I put it up to 84MB.

Why can this be happening? I only have 5000 clients!!! (and that report doesn't show any servers!)

Thanks for any help.

Jane

(in reply to jmcleish)

Post #: 4

RE: Can you display nulls in web reports? - 11/17/2008 10:59:10 AM

jnelson993

Posts: 959
Score: 132
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

So, you're saying that THIS report is timing out or the computer details report times out?

_____________________________

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

(in reply to jmcleish)

Post #: 5

RE: Can you display nulls in web reports? - 11/17/2008 11:00:04 AM

jnelson993

Posts: 959
Score: 132
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

And have you restarted IIS since you made the changes? I've had bad luck changing IIS settings and have them stick unless I do an IISRESET.

_____________________________

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

(in reply to jnelson993)

Post #: 6

RE: Can you display nulls in web reports? - 11/17/2008 11:20:29 AM

jmcleish

Posts: 513
Score: 17
Joined: 11/8/2002
Status: offline

Yes I did restart the website, the default website- but I've just restarted the IIS Admin service which seems to have done the trick now.

It was actually toggling between buffer limit errors and coming up with HTTP 500 Internal server errors!

Thanks so much John
:-)

Much appreciated.

(in reply to jnelson993)

Post #: 7