Can we have alert in k1000 when there is a difference in inventory detail from the previous one.
Hi All,
I have a some questions-
1) For example when i did the last inventory the Ram size in one of my workstation was 8GB and some one removed it and in the next inventory it was showing me the RAM size as 4GB.
Is there a possibility that if there is a difference in inventory ( hardware) then can we have a alert?
2) In License Compliance - Is there is any option where we can have report on license compliance that how many licenses are being used and how many are expired? Can we schedule reports in K1000, so that we can get the reports in weekly basis?
3) If i have all the systems managed through K1000, how can i stop/block/restrict any user from installing a particular software in the workstation using K1000.
I know we can block the particular software usage from the k1000 console by blocking it in the software catalog.
4)Where is white listing and Black listing in K1000?
5) When i use Wake on LAN to wake the system- how does it wakes the system, does it use the BIOS to wake the system using magic packet? Please tell me in detail how the system will wake up, what technology is used in that.
Thanks In advance.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
8 years ago
1. Changes in computer hardware should be listed in the asset_history table. This query will show assets that have had their RAM changed in the past day.
2. Yes, this should be possible. The front page should have a widget that gives an overview of some of this data and you should be able to configure alerts when a license is out of compliance. Reports can be scheduled to run and there is an option to only have them emailed if there are results.
3. I'm not sure that you can block installation but you can certainly generate a report of installations.
4. see above
5. It sends a magic packet to wake systems. If you have Dell Command|Configure installed on your Dell computers then you can use a script to schedule the BIOS to wake also.
SELECT * FROM ORG1.ASSET_HISTORY
WHERE
FIELD_NAME = "RAM_TOTAL"
AND TIME > DATE_SUB(NOW(), INTERVAL 1000 DAY)
3. I'm not sure that you can block installation but you can certainly generate a report of installations.
4. see above
5. It sends a magic packet to wake systems. If you have Dell Command|Configure installed on your Dell computers then you can use a script to schedule the BIOS to wake also.
Comments:
-
@chucksteel, Thanks for the reply, but i didnt find the answers more clear to understand,
Please tell me for the 1) where can i use that query?
2) can you tell me the steps? for scheduling the reports?
4) where above i need to see?
4) Can u tell me how this Packet works and does the the script to wakeup BIOS will be used only for Dell computers? - vishninja 8 years ago-
1 and 2) You would use the query to create a report. Go to Reporting, Choose Action, New (SQL). Enter the required information including the SQL query above.
To schedule the report browse to Reporting, Report Schedules. Click Choose Action, New and enter the required information.
4) I meant see the answer to number 3. There isn't a clear cut whitelist/blacklist per se.
5) This page can explain the magic packet better than I can:
https://en.wikipedia.org/wiki/Wake-on-LAN
The Dell Command|Configure software allows you to script changes to a computer's BIOS. If other manafacturers have similar software for their machines then you could use a script in the K1000 to perform similar tasks. I am only familiar with Dell Command|Configure, however. - chucksteel 8 years ago-
Changes in computer hardware, can we have alert? - vishninja 8 years ago
-
Yes, any changes should be reported in the asset_history table. Your original question was about changes in RAM and the SQL code I posted will report on that. Is there another hardware change that you are interested in reporting? - chucksteel 8 years ago
