Originally Posted by: Rick I 
for some reason all the kingston SSD drives still show as a normal drive my kingston SSD is labeled KINGSTON SA400S37240G
how would I amend this SSD audit to make sure kingston shows as a SSD
The report mainly checks whether the name includes SSD, since most SSDs will. In you case you can add the model name to the query so it is labeled as an SSD
Change:
Quote:Case When (tblFloppy.Model Like '%SSD%' Or
tblFloppy.Model Like '%Solid State%' Or tblFloppy.Model Like '%mSS%' Or
tblFloppy.Model Like '%mSATA%') Then 'Solid State'
To:
Quote:Case When (tblFloppy.Model Like '%SSD%' Or
tblFloppy.Model Like '%Solid State%' Or tblFloppy.Model Like '%mSS%' Or
tblFloppy.Model Like '%mSATA%' Or tblFloppy.Model Like '%KINGSTON SA400%') Then 'Solid State'
I noticed that Kingston has a range of A400 SSDs, so I used a wildcard instead of the exact model. I also updated the report in the report library.