Software License Compliance Report

Which version of Asset Management are you using?

I would recommend that you try defragmenting your SQL Server. I have attached a query (below) that I use to defragment my SQL.

If this does not work, then I'm afraid that you may have to wait until Asset 7.0 is released or attempt to rewrite the report.

declare
    @table_name varchar(255),
    @index_name varchar(255),
    @sql varchar(max),
    @frag_level int

set @frag_level = 30

declare TuneUp cursor forward_only
for
select
    so.[name] table_name,
    si.[name] index_name/*,
    ind.index_type_desc,
    ind.index_level,
    ind.avg_fragmentation_in_percent,
    ind.avg_page_space_used_in_percent,
    ind.avg_record_size_in_bytes*/
from
    sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, 'detailed') ind join
    sys.objects so on ind.object_id = so.object_id join
    sys.indexes si on ind.object_id = si.object_id
        and ind.index_id = si.index_id
where
    ind.avg_fragmentation_in_percent >= @frag_level
order by
    so.[name],
    si.[name],
    ind.index_level

open TuneUp
fetch next from TuneUp into @table_name, @index_name
while @@fetch_status = 0
begin
    set @sql = ''
    set @sql = 'alter index [' + @index_name + '] on [' + @table_name + '] rebuild'
    exec (@sql)
    set @sql = 'update statistics [' + @table_name + '] with fullscan'
    exec (@sql)
    fetch next from TuneUp into @table_name, @index_name
end
close TuneUp
deallocate TuneUp

--select * from sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, 'detailed')
 

I'm more of a user of the contract management piece and I can definitely confirm we have the same thing occur now and again. Sometimes in the Summary tab on the WIn32 record , sometimes on the collections.

Our administrator has mentioned the following to me in the past; too much running on one server, some process was sucking up resources it shouldn't have, a server reboot was needed, etc. He's mentioned some activity log files which seem to give him some leads as to what's wrong.

Asset Management Documentation - (do you have this schedule configured??) 

The Software License Evaluation page lets you allow the evaluation of all software

licenses on a schedule and specify the number of days after which software licensing

calculations are considered to be out of date.

To set a Software License schedule

1. In the Altiris Console, click the Configuration Tab.

2. In the left pane, select Configuration > Solutions Settings > Assets and
Inventory > Asset Management Solution > Software License > Software
License Evaluation.

3. In the right pane, select Enable Schedule.

4. Choose a schedule from the drop-down list.

5. Enter a number of days in the Automatic Expiration Field.

6. Click Apply.

Also, is the database separate from the Altiris Server? 

I  have question
this option :
Software License Evaluation

is availed in NS7 ????

Regards,
Michał Matukin