Friday 29 June 2018

google chrome error 0x8004070c solutions

if you are stuck with error 0x8004070c for re installation of chrome you should delete files from users→appdata→local→google
and also need to delete files from program files→google
foyou want remove denied permission from google folder contained in appdata and prgram files


C:\Program Files
C:\Users\Administrator\AppData\Local

change permission to delete this google folder

Tuesday 26 June 2018

Checking your RAM problem

Checking RAM problem is big head ache for IT technicians,
Here is small way to to check the RAM issues from windows operating system
mdsched.exe is small program which enable to check the RAM issues while booting ,

 Just Press windows+R to get run window and type mdsched.exe.
then system will restarted with a bluescrenn window press f1 to get extended resting and save the setting by pressing tab button

OR
goto windows→type→memory diagnostic→select →windows memory diagnostic→click it

Saturday 16 June 2018

Error: "Windows is unable to install to the selected location. Error: 0x80300001. on New seagate hard disk 500 GB

If you are getting this error then one of the solution i tried is partitioning hard disk using cmd
when i am creating a new partition it is not creating system reserved drive 100 mb also
then i opened cmd from there by pressing shift+F10 button
Now cmd will open
Now type
1.
diskpart
2.select your (#=1 or 2) Hard drive not pendrive
select disk #
3.
create part pri size=100 format fs=ntfs quick label="System Reserved"
4.
active
5.Now exit and reboot the system to install windows
exit 

Getting a list of installed program in your windows to text file and arranging in google sheet as drop down list

Open command prompt then type 
wmic 
Now add this line to get installed program list , this will saved to D drive location with file name as Installedsoftwaelist.txt
then type
/output:D:\Installedsoftwaelist.txt product get name,version
This means that save a text file with Installedsoftwaelist.txt containing the data with program name and its version

Now open your google sheet from drive.google.com
I  created Sheet1 to get all assets of my office and also
created new sheet2 and paste data from text file to Sheetlist1 (i renamed Sheet2 to Sheetlist1)


to get the list of application installed in each computer can view simply by adding data validation , i will show you todo it
now create asset sheet like this


Now we have data in in Sheet2 as renamed to Sheetlist1

Now we want all list of program in one cell here it is V4 cell

select v4 cell and goto data menu ->data validation->

criteria is select
List from a range-> fill with the data as
Sheetlist1!A1:A25

press OK
 now you can see list of program as a droplist manner
Here you can see the sheetlist1 data in V4 cell as like droplist menu







Poem aymen

 Aymen, a name that rings like a bell, A person of character, with stories to tell. With a heart full of kindness and a mind sharp and brigh...