|
|
Browse by Tags
All Tags » vNext (RSS)
-
-
If you are trying to install CM12 console on a workstation, you will receive the following error: Input string was not in a correct format. The solution is to browse the DVD and smssetup\bin\i386 and execute the AdminConsole.msi. 
|
-
-
-
For full details see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/38f96191-6e3e-4150-8f3a-18b1c4db8d7d SELECT
R.Netbios_name0,
R.AD_Site_Name0,
ARP.DisplayName0,
ARP.InstallDate0,
DATEDIFF(Day, CONVERT(Datetime,ARP.InstallDate0), GETDATE()) AS [days since installed]
FROM
dbo.v_R_System R
join dbo.v_FullCollectionMembership FCM on FCM.ResourceID = R.ResourceID
join dbo.v_ADD_REMOVE_PROGRAMS ARP on ARP.ResourceID = R.ResourceID
WHERE
(ISDATE(ARP.InstallDate0) =1)
AND ARP.DisplayName0 = 'Enhanced Web Reporting'
AND FCM.CollectionID = 'SMS00001'
and Datediff(dd,ARP.InstallDate0,getdate()) < 7
|
-
-
-
-
-
Well MMS 2012 is over and it has been crazy for me. Here is the summary of what happened: Luggage: -
So I know that a few people ask what the deal was with my luggage and it was so heavy. Well you would think that it was because I over packed or something like that. Nope, thanks to tips for both Ed and Rory over the years, I have slowly learn to not over pack. So what was it? -
2-1L bottles of Maple syrup from Stanley’s farm, Your welcome Kenny. -
2-750 ml bottle of Rum. Long story. -
Both weight in a 14 lbs.!  -
I had no problems with either US Customs or my flights!!! <knock on wood> -
-
-
MIF party as always, it was great -
-
The Meet and Geek was cool -
The closing party was good, I would say it ranks as the second best in MMS history -
-
Winning the CM12 Expert Quiz was nice but betting Wally was better. Here is the trophy! -
One last tidbit, my luggage was 50.5 lbs. returning home, go figure! 
|
-
-
-
For full details see: http://www.myitforum.com/forums/tm.aspx?high=&m=234978&mpage=1#234980 select
U.Name0 as 'Bruger',
-- U.displayName0 as 'Bruger',
MU.FullName as 'Brugernavn',
ou.ou as OU,
round(sum(MUS.UsageTime)/60.0,2) as 'Forbrug (min)'
from
dbo.v_R_System R
join dbo.v_MonthlyUsageSummary MUS on R.ResourceID = MUS.ResourceID
join dbo.v_MeteredFiles MF on MUS.FileID = MF.MeteredFileID
join dbo.v_MeteredUser MU on MUS.MeteredUserID = MU.MeteredUserID
join dbo.v_R_User U on U.Unique_User_Name0 = MU.FullName
left join (select OU.ResourceID, replace(max(ou.User_OU_Name0),'ITCSYD.LOCAL/BRUGERE/','') as OU from v_RA_User_UserOUName OU group by OU.ResourceID) as OU on OU.ResourceID = U.ResourceID
where
MF.ProductName = @RuleName
Group by
U.Name0,
MU.FullName,
ou.ou
order by
U.Name0
|
-
-
|
|
|