Client Management Suite

If there is possibility to create report from shared folders on each workstation? I need only folders that everyone have permissions to read or write.

Regards,

Ania

There are two now:

Inv_OS_File_Share

Inv_OS_File_Share_Windows

oh ... and none of them has any permissions inside.

Permissions are stored in:

Inv_OS_ACLs_Windows

You need the Resource Type "Share" there.

Here is a quick get you going script.

Hope this helps.

EDIT: To make it easier i've attached my report which is parameterised to allow you to restrict your search down to device name or whatever you like.

SELECT DISTINCT fsinv.[_ResourceGuid]
 ,[dca2_AeX AC Identification].Name
     ,fsinv.[Instance ID]
     ,fsinv.[Path]
     ,fsinv.[Name] as [Share Name]
     ,fsinv.[Description]
     ,fsinv.[File Sharing Protocol]
     ,fsinv.[Protocol Versions]
     ,fsinvwin.[Max Connections]
 
  FROM vRM_Computer_Item As vri1_Computer
 INNER JOIN Inv_AeX_AC_Identification As [dca2_AeX AC Identification] On vri1_Computer.Guid = [dca2_AeX AC Identification]._ResourceGuid
 LEFT JOIN [Altiris_CMDB7].[dbo].[Inv_OS_File_Share] AS fsinv on fsinv._ResourceGuid = vri1_Computer.Guid
 LEFT JOIN [dbo].[Inv_OS_File_Share_Windows] AS fsinvwin On fsinvwin._ResourceGuid = fsinv._ResourceGuid
 
  WHERE fsinv.[Name] != 'C$' AND
  fsinv.[Name] != 'D$' AND
  fsinv.[Name] != 'E$' AND
  fsinv.[Name] != 'IPC$' AND
  fsinv.[Name] != 'ADMIN$' AND
  fsinv.[Name] != 'print$'
GO

Attachment(s)

File Shares on a Device.xml   11 KB 1 version

Thank you guys!

Looks like I have plenty of learning to do to track down all the differences in 7.1 from 6.x...

i'm sort of fortunate i never really used NS6 too much.

its definately still not 100% straight forward to find what you need!

it would be nice to have a bulk collection of generic reports that could be batched up and imported for new starters.