Andrew Bosch

Profile

Member Profile

Andrew Bosch Symantec Employee

Status: -

Job Title: Senior Principle Software Quality Assurance Engineer

Member for: 4 years 33 weeks

Contribution Stats

102

Solutions

2

Forum Threads

589

Comments

5

Blog Entries

0

Ideas

1

Article

0

Videos

6

Downloads

0

Events

5

Groups Joined

Andrew Bosch's Activity

Show:

discussion comment 17 May 2013

Andrew Bosch commented on: Determine what "Role" a Computer object has

This should get you started. SELECT ci.Name AS Computer, i.Name AS [Role] FROM vRM_Computer_Item ci JOIN ScopeMembership sm ON sm.ResourceGuid = ci.Guid JOIN Item i ON i.Guid = sm.ScopeCollectionGuid ORDER ...

discussion comment 14 May 2013

Andrew Bosch commented on: Timestamp for "Last Start" time on Executable Usage metering report incorrect by 4 Hours

The time reported for application metering usage is in UTC. So, if your clients are on EST, that would explain the 4 hour difference. The only way to change this is to modify the SQL behind the report to convert the UTC time into ...

discussion comment 08 May 2013

Andrew Bosch commented on: Manually Running spPMWindows_ComplianceByComputer

The problem is your TrusteeScope. Try this: spPMWindows_ComplianceByComputer @StartDate = '5/5/2012' ,@EndDate = '5/5/2013' ,@TrusteeScope = '{2E1F478A-4986-4223-9D1E-B5920A63AB41}' --Symantec Administrators

discussion comment 02 May 2013

Andrew Bosch commented on: query for retired systems

Sorry, I fixed it.

discussion comment 02 May 2013

Andrew Bosch commented on: query for retired systems

SELECT ci.* FROM vRM_Computer_Item ci JOIN ResourceAssociation ra ON ra.ParentResourceGuid = ci.Guid AND ra.ResourceAssociationTypeGuid = '3028166F-C0D6-41D8-9CB7-F64852E0FD01' AND ...

discussion comment 02 May 2013

Andrew Bosch commented on: CollectionMembership cm

Pretty much everything uses ResourceTargets now. Membership is held in the the ResourceMembership table.

discussion comment 12 Apr 2013

Andrew Bosch commented on: Software View - Computers with software installed - Last Used Install Date

The NS.Nightly schedule is a backup to the default mapping process. When a software component is discovered via Inventory, it is sent to the NS. If it is a component that already exists, then it simply merges. If it is a new ...

discussion comment 20 Mar 2013

Andrew Bosch commented on: Software View - Computers with software installed - Last Used Install Date

'Install Date' comes from the Inv_InstalledSoftware table, which is populated when software inventory is run. If that column is blank in the database then there is no way for the UI to show anything. 'Last Used' comes from ...

discussion comment 20 Mar 2013

Andrew Bosch commented on: Saved search computers newer that 3 days !

You can't overwrite a default saved search. You can modify/add search criteria and then save it using the blue disk icon. If you don't save it, then all your modifications will be removed once you click on something else. ...

discussion comment 14 Mar 2013

Andrew Bosch commented on: Patch Compliance Data

Run the Compliance Summary report on the parent NS under Reports->Software->Patch Management->Compliance. It is the ONLY report that shows compliance for all servers. This report will list all your child NS's and their ...

discussion comment 13 Mar 2013

Andrew Bosch commented on: Patch Compliance Data

Detailed Patch Compliance data does NOT replicate up the hierarchy to the parent - only summaries. When you run the compliance summary report and drill down into a specific server, it is actually running a more detailed report from that ...

discussion comment 25 Feb 2013

Andrew Bosch commented on: Need help creating a Filter based on software Publisher

Here is some SQL to search by company name... SELECT iss._ResourceGuid, ci.Name, sci.Guid, sci.Name AS Software, company.Name AS Company FROM vRM_Software_Component_Item sci JOIN Inv_InstalledSoftware iss ON ...

discussion comment 19 Feb 2013

Andrew Bosch commented on: How to restrict access to adding "Saved searches"

There is currently no way to restrict access to creating saved searches. In the next version we have implemented a way to prevent users from created them.

discussion comment 06 Feb 2013

Andrew Bosch commented on: symantec management agent for linux

Good point Mike. Make sure you can ping both the hostname of the NS and the FQDN. If not, you'll have to add an entry to the hosts file.

discussion comment 05 Feb 2013

Andrew Bosch commented on: what is the preferred method to move software from the installed products list to unmanaged

Go to Manage->Software Catalog. You'll see all your installed software products in the upper right-hand grid. Highlight the product you wish to move to Unmanaged, and then use the directional in between the Managed Products and ...

discussion comment 05 Feb 2013

Andrew Bosch commented on: symantec management agent for linux

The base altiris agent needs to run with admin priviledges to install. If you are manually installing, just use 'sudo' and then the name of the package. During install, it will 'su' as needed and then will run as root during normal operation. ...

discussion comment 05 Feb 2013

Andrew Bosch commented on: Sending updates to managed server, but not to install them updates

One option is to create a policy with an installation schedule of sometime WAY in the future. Then the updates will get queued up for install and then the respective admin can start the install anytime he wishes. For example, I've seen ...

New download 04 Feb 2013

Andrew Bosch posted: Client Tasks to Block/UnBlock IE10 on Windows 7

Microsoft recently announced the release of a toolkit to disable the automatic delivery of IE10 to Windows 7 computers. I have taken the provided scripts and created two client tasks (Task Server) - one that will create the registry key to block the install of IE10, and another one ...

discussion comment 29 Jan 2013

Andrew Bosch commented on: Report to determine PC Availability

This should get you what you need. A caveat is that if a machine is part of multiple Organizational Groups, then it will list all of them. We can always filter out specific ones if you want. SELECT ...

discussion comment 29 Jan 2013

Andrew Bosch commented on: Report to determine PC Availability

The logon/logoff information is updated when the Altiris Agent detects one of those events on the PC. So, it is almost "realtime". The biggest bottleneck will be the NS itself processing the NSE's and then updating the ...