Video Screencast Help

Need to created an report with all the user desktop info

Created: 25 Feb 2013 | 14 comments

I need to created a custom report that collect all the users desktop information. they are in the C:\Document and settings\%users%\desktop\*.*

where is the table name and field that I can extract it.

 

Thanks for advance

 

Lillian

 

 

 

 

Comments 14 CommentsJump to latest comment

SK's picture

You will need to create a custom inventory to obtain that data, which will then allow you to create a report that targets its custom data class.

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

llian's picture

I know how to create custom inventory, but where is the table name and field name for this?

 

Thanks

 

Lillian

 

SK's picture

Once you create the custom data class, it will be found in the database.

Once you have created, deployed and received data back from the custom inventory run script task, that table will be populated.

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

AngelD's picture

The name of the custom inventory table would be named Inv_<name of the custom inventory data class>

llian's picture

I called Altiris technical support, they told me don't need to create data class, he show me create new policy to collect those info, so I create new policy is call My file scan, then click Advanced button, then click FIle Properties Scan Setting, click folders, please see the attchment

When job is finished, I need to know where I can get those data, can someone help me

 

Thanks

 

Lillian

 

AttachmentSize
Desktop.doc 132.5 KB
SaschaH's picture

Maybe try this SQL in a Raw SQL report. Its easier to get the info from the views, else you can check the views for the base tables, but they will need even more joining. And make sure to uncheck report size/file count only for the files you are interested in usually only program files will be saved in the db.

select f.Name,

iifd.Path

from vFile as f left Join

Inv_Installed_File_Details as iifd on f.Guid = iifd.FileResourceGuid

where iifd.Path like 'C:\Document and settings\%' and iifd.Path like '%\Desktop%'

Bechtle – your strong IT partner. Today and tomorrow

If that seems to help, please "Mark as Solution"

SaschaH's picture

Just rediscovered, you can also use the Audit Software Search report and search for the File Path.

Reports > Discovery and Inventory > Cross-platform > Software/Applications > General Software

Bechtle – your strong IT partner. Today and tomorrow

If that seems to help, please "Mark as Solution"

llian's picture

if I use

Reports > Discovery and Inventory > Cross-platform > Software/Applications > General Software, yes, I can only see all the file extension with exe file only, nothing else, but I need to see the list of file name and folder name as well.

How can I do that?

someone was telling me need to create the data class, but I need to get VBscripts work before I can create the custom data class

Thanks for the help

 

Lillian

 

SaschaH's picture

Clone a inventory policy yu can find in and change some settings in advanced.

Manage > Discovery and Inventory > Inventory > Collect Full Inventory (CLONE) > Advanced

File Properties Scan Settings > Files

There you can change which files get scanned how. By default only program files get scanned in detail with path and file properties. All other files that are rules in there for are only counted and size checked.

Best clone a inventory rule, take all unwanted things out, for example no need to scan rest of the drive if you only want infor from C:\Documents and Settings\.

I dont know if you can add a wildcard in the Files Rules. Give it a try else you would need to make one for every filetype you want to scan for.

Some more info on this.

http://www.symantec.com/business/support/index?page=content&id=HOWTO63516

Bechtle – your strong IT partner. Today and tomorrow

If that seems to help, please "Mark as Solution"

SK's picture

This is why I said you will need to use custom inventory, as a users desktop can contain any file type.

I believe that WMI has a number of desktop classes that may or may not be helpful.  If not, you will need to use a method that will interrigate the actual desktop folder.

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.

llian's picture

I use the dos prompt like this

c:>Documents and Setting> dir *.* "%userprofile%"\desktop > filename2.txt

when I open this filename2.txt, and this is exactly I want it,

how can I use this to create the custom data?

Need HELP.....

 

Thanks

 

Lillian

AttachmentSize
filename2.txt 5.21 KB
Sachin Sawant's picture

Hi,

Kindly check this query.

 

SELECT distinct dbo.Inv_AeX_AC_Identification.[Name]
,dbo.Inv_UG_User_Account.[User Name],[Full Name]
FROM
dbo.Inv_AeX_AC_Identification,
dbo.Inv_UG_User_Account
WHERE
dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_UG_User_Account._ResourceGuid

 

 

llian's picture

I run this query, and it gave me output like Name, UserName, FullName.

What do I need this for my custom data?

 

 

Sachin Sawant's picture

That means you won’t report, how many file and folder available in user Desktop.
If, its yes pls reply me.