HP Insight Remote Support and Windows Server 2008

(So that this gets into google and maybe someone else can learn from it.)

HP Insight Remote Support, when running on Windows Server 2008 has some irritating undocumented “features”.

  1. You need an entry in %systemroot%system32driversetchosts for the local machine and it’s IP address. If you don’t have this, the RSS Insight Admin Console will not be able to resolve the IP of the local machine and you will get “Unresolved” in the IP Address column of the Systems tab.
  2. Remote Support Software Manager does not like UAC. Since the Manager app is an hta application, the way around that is to Right click an Internet Explorer icon and select “Run as Administrator”, then browse to “C:Program Files (x86)HPCMRSSWMGUIswmui.hta” and open it.

More Handy SQL

To update an old post, here’s some SQL for listing out BIOS versions per model from WSUS 3:
SELECT COUNT([tbComputerTarget].[IPAddress]) as Count,
[tbComputerTargetDetail].[ComputerModel],
[tbComputerTargetDetail].[BiosVersion]
FROM [SUSDB].[dbo].[tbComputerTarget]
JOIN [SUSDB].[dbo].[tbComputerTargetDetail] on [tbComputerTarget].[TargetID] = [tbComputerTargetDetail].[TargetID]
group by [tbComputerTargetDetail].[ComputerModel], [tbComputerTargetDetail].[BiosVersion] order by [tbComputerTargetDetail].[ComputerModel]

Grandma Betka

Rest in peace, you are and will be missed.

HOOPESTON – Florence E. “Floss” (Nelson) Betka, 89, of Hoopeston passed away at 6:05 a.m. Tuesday, Dec. 21, 2010, at Carle Foundation Hospital in Urbana.

Mrs. Betka was born on Dec. 6, 1921, in Granite City, the daughter of James E. and Florence (Story) Nelson. On Sept. 20, 1946, she married Kenneth Betka. Her husband preceded her in death on April 4, 2006.

Floss is survived by two daughters, Sue Betka of Washington, D.C., and Jean (Tom) Skoza of Champaign; one son, Bill (Melva) Betka of Cissna Park; three grandchildren, Corey (Alisha) Betka of Champaign and Rachel and Warren Skoza of Champaign; two great-grandsons, Robin and Jonathan Betka of Champaign; and two sisters-in-law, Kathryn Nelson of St. Louis and Margaret Hurliman of Martinton.

She was preceded in death by her parents; her husband; a son, Robert; a daughter, Lois; three brothers, Willie, Clyde and Harold Nelson; and a sister, Selma Nelson.

Mrs. Betka graduated from Eastern Illinois University and taught at the East Lynn High School for several years. She and her husband lived on the centennial family farm for nearly 46 years.

Floss also taught Sunday school for the high school children at the East Lynn United Methodist Church. She was also a homemaker who especially enjoyed tatting, sewing, crocheting, quilting, reading and sports.

Funeral services will be held at 1 p.m. Monday, Dec. 27, 2010, at the Anderson Funeral Home, 427 E. Main St., Hoopeston, with the Rev. Janet Eggleston officiating. Burial will be at East Lynn Cemetery, East Lynn.

Visitation will be from 11 a.m. to 1 p.m. Monday, Dec. 27, 2010, at the Anderson Funeral Home in Hoopeston.

Doctor visits and first Hospital Stay

So, Jonathan had an elevated bilirubin level while he was still in the hospital, so we had our first doctor visit the day after discharge. His level was still high, so we got another visit for the next day. At that second visit, his bilirubin was even higher, so he was admitted to Pediatrics for a 12 hour stay under a Bili light. He had dropped to 7 lbs even before being admitted, but is up to 7 lbs 1 oz by discharge.

He’s home now and seems to be feeling, eating and pooing much better.