GarthMJ

There is no way to edit this via SQL. If it is available, it will be within the CM07/CM12 SDKs. Have you look in there yet?

Are you looking for a report or a collection query? You state report but you posted a collection query, so... If you are looking for a report have you looked at the built-in reports, what wrong with them.

There are no built-in web portals to do what you want. You will need to do one of the following. Look at 3rd solutions, like Flexera or 1e. Look at something like SCSM with orchestrator Advertise to a security group and have the HD add the user or pc into the group keep in mind that a logon / reboot is need to get this to work Personally I would try the 3rd party solutions.

So describe the process that you want your HD admins to use to install the software. This will give us a better idea as to pointing you in the right direction to deploy the SW to the PCs. aka do they logon to the PC and trigger the install Do they add the PC into a group Do they add the user into a group What is you SLA to install the SW? etc...

The Select * will allow you to see more information about the PC, instead of just the PC name as you have it now.. either way I’m glad it is working for you.

Why can’t you do that? Admin are just users, You can target SW to Admins and since the SW is target to Admins only, admins are the only ones that can see it and install it. Personally I avoid like the plague giving out the CM12 console to anyone. Instead I use security group to target software, this allow Helpdesk staff to add a user to a security group and the software will be installed after the user login. IMO the real question that you need to answer is what are you trying to do. Are you trying to create a web interface to allow HD to install software remotely on a PC or do you want the Admins to logon to each PC and install the SW.

If you have user AI enabled this will do the trick. select CS.Name0, SCU.LastConsoleUse0 from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_SYSTEM_CONSOLE_USER SCU on CS.ResourceID = SCU.ResourceID where SCU.SystemConsoleUser0 = <Userid>

First off, I would do Select * ... Secondly, Change the = to Like and everything will be good.

Everything look fine. Except you need to browse to <servername>/Reports instead.

Check your MP and review the client logs to see why it is not talking to the MP.

you can use Net helpmgs <error#> to determine what the error # means. Error 2 = The system cannot find the file specified.

So you are look for the sms_def.mof and configuration.mof then. I can do that but mine will have a ton of extra stuff in it and I do mean a ton of extra stuff! Plus, if you have already enabled those attributes within the class that is all you need to do. You should look at the inventoryagent.log and confirm that the data is collected. Then confirm that local class is displaying data (aka not Null) and finally confirm that CM12 is getting the data by forcing a full inventory.

No, there is not way for me to export my HW inventory. I have this feeling we are talk about Apples and Oranges.

No there is not way to export HW inventory and import into CM07 / CM12.

I have only see that happen when SSRS is missing CU or SP. It should work otherwise.. I would re-apply the CUs to your SSRS server.

Are you ask or telling me?

What I means is, Did you enable those check boxes or change them? Can you give an example of a report that is giving you issues. This will help us, understand which WMI class is having problems. -2147217406 = 0x80041002 = WBEM_E_NOT_FOUND

So that looks good. Did you enable them? What report is giving you problems? BTW Once a hour for HW Inv is fairly aggressive. Daily is what I recommend.

Search for Memory within the Hardware inventory, there are 4 attribute that are enabled by default, the only one that is NOT enabled by default is Available Virtual memory.

Logon time is more of an AD question, not a CM07 question.

Stupid question but why do you think it is not working? Have you forced a Full Discovery?

This report will get you started. http://smsug.ca/blogs/garth_jones/archive/2008/02/04/basic-all-in-one.aspx

Sure you can do that. You would need to write a custom report . here is an example. http://smsug.ca/blogs/garth_jones/archive/2013/01/16/pc-serial-number-by-ou.aspx

Different domain or different forest?

I don’t think you can do anything about DA going down. (Yes, you can look at IBCM but I don’t think that is practical in this situation DA does with IBCM does so….) If they can’t get to your DP, MP, and SUP, there isn’t much you can do to help them. If this become a big issue, I would work on why they are getting out of sync ( or can’t access DA) vs trying to come up with a work around for those that do get out of sync. One suggestion would be to allow one MP, SUP and DP to existing in the unprotected (NAP) network, thereby allowing client to be able to update themselves when they do exist there.