Need help on a report

[dteague]

OK, been having issues with the report writer crashing on me, or hanging sometimes. When it works it's great.

I'm hoping someone can help me, as it has been years since I have done much in SQL. What I need is a list of computers that their name does not match their IP address's 4th node.

i.e. ABCCOMP043 should have an IP address of 10.0.0.43 if it had an address of 10.0.0.44 I would want it to show so I can rename the computer. Can someone help me out?

Thanks!

[dteague]

The Hangs, seems to happen all the time in report writer when I am trying to write a query. It usually happens when I am in the SQL tab trying to write an SQL statement, and it will "hang" and take 1 processor up to 100% and after a few minutes it will do one of 2 things, it either comes back, or it just stays there, and I kill the task. It's running on a VM that we have devoted 4 processors and 4G of memory.

I've also noticed that sometimes the query will not run unless I bounce thru the tabs a few times, as it doesn't produce the results after I change a query.

[Hemoco]

dteague wrote:
I've also noticed that sometimes the query will not run unless I bounce thru the tabs a few times, as it doesn't produce the results after I change a query.

This is a known problem, an update will be released for it soon.

[Hemoco]

dteague wrote:
OK, been having issues with the report writer crashing on me, or hanging sometimes.

Do you know when exactly this happens so we can try to reproduce this?