How to Update Daily IT asset [Laptop & Desktop] in Big Organization with Given step.
How to Update Daily IT asset [Laptop & Desktop] in Big Organization with Given step.
Step 1.
List out the User & Asset data in given column.
1. User Name
2. Department
3. Location
4. Site
5. Domain.
6. Organization Serial number.
7. Domain register name.
8. Laptop or Desktop Model type eg :- HP Probook 440 G4.
9. Service Tag :- Serial No.
10. CI type
11. Asset Tag No.
12. OS type eg:- Microsoft Windows Pro 10
13. Acquisition Date
14. Expiry Date
15. Warranty Expiry Date.
16. Vendor Name
17. Purchase cost eg. 36000 Rs for Laptop
18. Asset status i.e. In Use/In stock/Repair/Expired/Disposed
19. Asset Type i.e Laptop or Desktop etc
Step 2.
Import above data of user and its asset from Application or your store format.
Step 3.
Sava that data in excel format.
Step 4.
Pivot the table with Site & Asset status.
Step 5.
Copy the summary & send it the required concern person or use it for your own data analysis.
Be happy.
Step 1.
List out the User & Asset data in given column.
1. User Name
2. Department
3. Location
4. Site
5. Domain.
6. Organization Serial number.
7. Domain register name.
8. Laptop or Desktop Model type eg :- HP Probook 440 G4.
9. Service Tag :- Serial No.
10. CI type
11. Asset Tag No.
12. OS type eg:- Microsoft Windows Pro 10
13. Acquisition Date
14. Expiry Date
15. Warranty Expiry Date.
16. Vendor Name
17. Purchase cost eg. 36000 Rs for Laptop
18. Asset status i.e. In Use/In stock/Repair/Expired/Disposed
19. Asset Type i.e Laptop or Desktop etc
Step 2.
Import above data of user and its asset from Application or your store format.
Step 3.
Sava that data in excel format.
Step 4.
Pivot the table with Site & Asset status.
Step 5.
Copy the summary & send it the required concern person or use it for your own data analysis.
Be happy.
Comments
Post a Comment