2 users responded in this post

Subscribe to this post comment rss or trackback url
User Gravatar
Lee_cz said in April 1st, 2011 at 7:47 pm

Thanks for this query, i used it for my HW Model report but i would like to ask for an advice.

Problem im facing at moment is that in our environment we using set of various HP laptops models. Unfortunately HP is putting to HW model name also number of actual HW series.

Thats why in report i produce by your SQL query im getting for one model number of lines which differs just by SERIES. Example:

HP Compaq 6510b (GB866EA#AKB)
HP Compaq 6510b (GB867ET#ABU)
HP Compaq 6510b (GB868EA#ABB)

See from a query point of view each is a different model but its not. So im getting count for each of this line, i would like to have 6510b TOTAL number.

Can u advice how to filter out these details in brackets?

many thanks

VA:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)
User Gravatar
danovich said in April 5th, 2011 at 12:18 pm

No idea, I’m not a SQL query expert. I would simply manually manipulate the data in Excel.

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)
Leave A Reply

 Username (Required)

 Email Address (Remains Private)

 Website (Optional)